How to count number of dimensions on a pivot table

[Anonymous]

Hi everyone,

I have a pivot table, listing sizes and stores for each size that sold out.

the pivot table is attached to this discussion.

basically all I wish to do is to count the number of stores for each size.

this subtotals must be shown at the top of the store dimension for each size.

partial sum doesnt seem to work in this regard?

thanks everyone

[sunny_talwar]

Subtotal might work if you use this expression for stock quantity:

If(Dimensionality()= 1, Aggr(Count(Stores), Size), yourCurrentExpression)

HTH

Best,

Sunny

[jpenuliar]

you can look into Dimensionality():

How to use - Dimensionality()

you can also search for Alternate Pivot Total by Rob Wunderlich

[sunny_talwar]

You don't even need Aggr I guess, simple count is also working:

If(Dimensionality()= 1, Count(Stores), yourCurrentExpression)

Also find attached an example.

Best,

Sunny