Subtotals in Straight Table

[bmensing]

Hello there,

i know that its possibly to get sub totals in a straight table by using the Dimension Limit Tab in Proberties.

For examble, i got two dimensions "Year/cw" and "Date", when i check the box Show totals on the second Dimension "Date", i ll get

several empty rows for "Year/cw" without data... i want to hide these rows...

Nachricht geändert durch Bernd Mensing

[Anil_Babu_Samineni]

Better if you provide sample mock up

[bmensing]

its like

YEAR/CW     DATE    AMOUNT

2017/1           SubTotal 0,00

2017/2           SubTotal 0,00

2017/3           SubTotal 0,00

2017/4           SubTotal 140,12

i want to hide the first three rows...

[Anil_Babu_Samineni]

Do you un check the Suppress null value from presentation Tab?

[#5]

Please check the Presentation tab for the chart and Check the option "Supress Zero-Values"

[bmensing]

i've done that so far but the rows are still there...

[#7]

Is the Amount column defined as a dimension or as an expression?   The suppress zero values option will only impact expressions.  Make sure the logic for the Amount is defined on the Expressions tab, and not on the Dimensions tab of the chart properties.

[bmensing]

i ve created a sample, hope that will help!

[#9 · Accepted solution]

I agree, that behaviour looks a bit quirky.

You could try replacing the Dimension definition for Date using this formula:

=If(Aggr(Sum(Amount), Date)<>0,Date)

Switching to a fully expanded pivot table also seems to work (but you lose the sorting of the straight table then).

[bmensing]

Thank you so much, this is the perfect solution... needless to say that the Pivot is much slower due to the Performance...