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 ?
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 ?