Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I want to be able to total the subtotal amount. How can I do that?
This as you know gives me the Total of the whole column (CY - Territory).
Sum(Total{$<Brand={'xyz'},[Reporting Group]={'xyz'}>}[# Amount])
Region | Territory | CY - Territory | CY - Territory XYX |
Atlantic | XYZ | $1,088,104.54 | $46,691,919.06 |
Atlantic | ABC | $1,130,739.79 | $46,691,919.06 |
Atlantic | Total | $2,218,844.32 | $46,691,919.06 |
I would like to know the subtotal amount. How can I do that?
Region | Territory | CY - Territory | CY - Territory |
Atlantic | XYZ | $1,088,104.54 | $2,218,844.32 |
Atlantic | ABC | $1,130,739.79 | $2,218,844.32 |
Atlantic | Total | $2,218,844.32 | $4,437,688.65 |
Thanks,
J
May be this
Sum(TOTAL <Region> {$<Brand = {'xyz'}, [Reporting Group] = {'xyz'}>} [# Amount])
10 Trillion thanks. SOLVED!
Please note. I am only a front end user and I am using pivot table. If this cant be done in a pivot table how to do it in a straight table.
May be this
Sum(TOTAL <Region> {$<Brand = {'xyz'}, [Reporting Group] = {'xyz'}>} [# Amount])
10 Trillion thanks. SOLVED!