Issue with pivot chart subtotal

[sergio0592]

Hi all,

I'am facing an issue with subtotal. I have a pivot chart with  13 dimensions and 2 expressions (Z, Y). I'd like display in sub total for dimensions J and L a sum or avg. (first snaphot below)

I manage to display this only if i tick the "Show partial sum" for J and L. But the formatting pivot has changed.(see second snapshot below) .

So i want only subtotal for dimensions A and B, but display formula for dimensions J and L. Is there a way to achive this without having to put J and L in expressions.

Regards

[sergio0592]

Don't works, return 4 like with just =Count(Distinct Month)

[sergio0592]

I manage to get 4 and 3 in calculated dimension with =aggr(NoOfRows(),Country,Month). But can't get it in subtotal...

Please stalwar1‌ help us !!

[sunny_talwar]

Subtotal can only show a single value (mostly used to show the text 'Total'), but you might be able to play around using the Pick(Dim(...)) technique or play around with this Partial Sums in straight table | Custom Labels in Pivot SubTotals

[sergio0592]

Thanks for your reply. Can't understand how pick function can be helpful but in order to get a single value in subtotal, i use min and max with =min(aggr(NoOfRows(),Country,Month))

                                    =max(aggr(NoOfRows(),Country,Month))

I have value for Russia in one chart (4) and value for UK (3) in an other but can't get in the same chart.

[sunny_talwar · Accepted solution]

This is what I implied

[vishsaggi]

Pick with ISLAND Dim table load helped me in few situations like a charm. Thanks very much Sunny for this trick.

[sergio0592]

Thanks a lot for your help and for this useful trick!!