conditional subtotal pivot

[#1]

hi.

is it possible to have conditional subtotaling based on a dimension?

for example i have two article types seperated by the first digit, i.e 9001, 8001.

when the article type = left(Articletype,1) = '8' i wish to supress totals or show 0 in the total cell, however when left(Articletype,1) = '9'

i wish to show the total in the Total cell.

i have attached my document for more insight.

Best

Brad

[swuehl]

I get an error opening your app, but anyway, I think you can't hide / disable subtotals based on dimension values.

You can however use dimensionality() / secondarydimensionality() in your expression to check if your expression is evaluated in subtotal context, then use a condition on Articletype to create what you want.