pivot table: how to build subtotals?

[#1]

Hi all,

i want to build subtotals for the dimension "Ratenschema", but i dont know how to do.

The subtotals should be for the column "Anzahl Paletten (PAE)   Formula=  [Anzahl Artikel] * factor

How can i avoid the "-" in the fields?

Thanks and regards,

Sabrina

[marcus_sommer]

You could enable sub-totals within the object properties in tab presentation (top left) and bottom left you could set options how NULL and EMPTY will be displayed.

- Marcus

[#3]

subtotals is already checked 😞

[marcus_sommer]

Have you set the subtotals for each dimension which you want?

[jonathandienst · Accepted solution]

It looks like you are using expressions which cannot be evaluated at a total and subtotal level.

This is usually caused by 'naked fields", ie fields used in the expression not enclosed in an aggregation function (like max(), sum() etc). These field values cannot be evaluated at the total/subtotal level as they have more than one distinct value at that level.

You may need an Aggr() function to calculate this column. Something like:

Sum(Aggr(<your existing expression>, unit_id, Ratenschema)

See also here

Conditional Aggregations

[#6]

yes, its done!

[buzzy996]

try this

[#8]

It works fine! Thank u all!! 🙂