Pivot table issue help

[#1]

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 ?

[martinpohl]

so uncheck the subtotal on dimension 3

regards

[#3]

The second column is calculated based on the expressions...unchecking doesnt help.

[#4]

stalwar1‌ Do you have any solution as always please

[sunny_talwar · Accepted solution]

See if this helps

[vishsaggi]

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.

[sunny_talwar]

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

[vishsaggi]

No problem, appreciate that.

Thanks,
V.

[#9]

Perfect.Thank again.One question...how can I have total as last row after ATT and Verizon row ?

[sunny_talwar]

Made the modification to the dimension and the expression