Quickview totals

Question

can you add totals to all the columns in a quickview?&nbsp; not with excel formulas

NicolasArgente · Answer

In Spreadsheet, using&nbsp;formula like XFGETCELL it would be possible. But not directly from the quickview. Maybe VBA can help, if you use the excel addin.&nbsp;Or if you import your quickview from a cube view, then the total is inherited from your cube views

aricgresko · Answer

The easiest way is to use the hierarchy's parent members, i.e., Revenue + Cost of Revenue = Gross Profit, so Gross Profit would be your total column.&nbsp; If that isn't available, you can use the Member Filter Builder to do some math.&nbsp;&nbsp;&nbsp;

Forum Discussion

Quickview totals