Quickview totals

RustyShacklefor
New Contributor II

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

2 REPLIES 2

NicolasArgente
Valued Contributor

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

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

aricgresko
Contributor III

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.  If that isn't available, you can use the Member Filter Builder to do some math.  

aricgresko_0-1658144604023.png