Can I alter subtotal values in a Pivot table?

[lcontezini]

Hi everyone,

I have a pivot table with two dimensions (store and salesman), and an expression with the goal expected for the current month. The problem is that the goal for the whole store is different from the sum of each salesman's goal. Is it possible to change the subtotal's value (store's goal) by any way?

[swuehl · Accepted solution]

You can use Dimensionality() or SecondaryDimensionality() function to check in which level (partial sum or detail row) your expression is evaluated.

[Anonymous]

Hi Leonardo:

Dimensionality ( 😞

Returns the number of dimension columns that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates.

A typical use is in attribute expressions, when you want to apply different cell formatting depending on aggregation level of data.

This function is only available in charts. For all chart types except pivot table it will return the number of dimensions in all rows except the total, which will be 0.

SecondaryDimensionality():

returns the number of dimension pivot table rows that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates. This function is the equivalent of the dimensionality() function for horizontal pivot table dimensions.

The secondarydimensionality() function always returns 0 when used outside of pivot tables.

Regards!