Issue in pivot Table

[vipin_mishra479]

Hi All,

I have create a pivot table and showing data subtotal wise

but i want to apply some condition please tell how can i do this.

Here i attached 1 screen shot image of pivot table here i highlight 1 subtotal which i don't want to show other than i want show please look into this.

[rbecher]

Hi Vipin,

this very depends on your data and aggregation expressions. Please upload a sample app.

- Ralf

[vipin_mishra479]

Hi Ralf,

PFA

[rbecher]

I guess you can only suppress the whole NULL segment:

Check on Dimension Segment: Suppress When NULL..

- Ralf

[vipin_mishra479]

No i want to show null value but i don't want to show null total..... how can i do this..

[kuba_michalik · Accepted solution]

That's a bit of a wildshot (I can't view your app right now), but maybe wrapping your expression in something like:

If(Dimensionality()=2 and IsNull(Only(Segment()),0,<OriginalExpression>)

and enabling "Suppress zero rows" would help? This should (in theory) zero out all totals for null segment, and then Suppress zero would take care of hiding them.

[rbecher]

Wow, interesting approach. This seems to work:

=If(Dimensionality()=2 and IsNull(Only(Segment)),0,Sum(Amount))

..maybe to be sure use this:

If(Dimensionality()=2 and IsNull(Only(Segment)),Null(),Sum(Amount))

[vipin_mishra479]

Hey Jakub,

How can I hide last 2 total.

I have attached the application.

[vipin_mishra479]

Solve Its Thanks Guy's