Add custom total

[Anonymous]

I have a filter comp

How could I add a custom total below total with the same expression but with the condition of comp = O?

[Chanty4u]

i thnk u can create a textobject and give the expression which vil give u the total on dat obj..

hope this helps u

[tresesco]

Use dimensionality() like:

If(dimensionality()=0, 'YourExpectedoutput' , Sum(sales))

[roger_stone]

Maybe you could look at adding a dummy Department?