Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a pivot table, a subtotal or total will apply the same formula as the detailed measure, e.g. if your measure is sum(Sales), the total will also be sum(Sales). This cannot be modified directly, though you can use Dimensionality() to force a different formula for subtotals / totals if desired.
Can you please give me an example of how to use this function Dimensionality() in my case.
thaks
Unfortunately not - you've included no details about your existing dimensions, measures, or data structure, just a screen capture of some numbers. I'd suggest checking the documentation for examples: