Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have attached test QVW and the excel file.
I have 3 expressions but I dont want to show total on each Status level insted I only want the total of those expresions at the end as attached screenshot.How can I do that ?
so uncheck the subtotal on dimension 3
regards
The second column is calculated based on the expressions...unchecking doesnt help.
stalwar1 Do you have any solution as always please
See if this helps
Hi sunny, this is very interesting showing multiple subtotals/totals in the last for a pivot table. I am trying to get my head around this, if not much pain would mind explaining the below stuff a little more :
1. Two tables created with Dim and Dim2?
2. =Pick(Dim2, PSSiteSubmittalStatus, 'Total') ?
3. =If(Dim2 = 2, Pick(Dim, 'Total', 'ATT', 'VERIZON'), '') ?
Apologies if I am asking too basic ?
Thanks,
V.
Vish -
Right now I am trying to get something done, but I promise to go over this (either here or a blog post) to explain the logic behind what I have done.
Best,
Sunny
No problem, appreciate that.
Thanks,
V.
Perfect.Thank again.One question...how can I have total as last row after ATT and Verizon row ?
Made the modification to the dimension and the expression