Subtotals in pivot tables

[tim_leijen]

Goodmorning,

Im setting up the below pivot table, and need to create subtotals on the first dimension only (channel)

However I've never done this before, so I don't know where to do this.

So how do I create subtotals per channel?

gr

[Anil_Babu_Samineni]

Looks like this is Pivot Table only, Can you check in presentation tab as "Partial Sum" for first dimension and then use

[ahaahaaha · Accepted solution]

Hi,

[arvind_patil]

Hi Tim,

Please provide sample data.

Thanks,

Arvind Patil

[qv_testing]

Presentation ==> Partial Sum should be Account Group

[tim_leijen]

Hi Andrey! Thanks, didn't know it was this simple, I was actually thinking I had to add a formula in the dimension! It worked!

[ahaahaaha]

Was glad to help you.