Pivot table total

[priyarane]

Hi Experts,

I wanted to remove particular amount from Total in pivot table;

Attached my Qvw and requirement.

[kristoferahlin]

Hi Priya,

Please check if the attached solution meets your requirements.

Regards,

Kristofer

[jpenuliar]

use this expression:

sum({<[Standard.Sub-Item1]={'*'}-{'Off-balance sheet securitization exposures'}>}[Standard.PQ 2])

[jsanchezh]

try with this expression:

     sum({<[Standard.Sub-Item1]-={'Off-balance sheet securitization exposures'}>}[Standard.PQ 2])

Kind regards

[jagan · Accepted solution]

Hi,

Try this expression

If(RowNo() = 0, sum({<[Standard.Sub-Item1]-={'Off-balance sheet securitization exposures'}>}[Standard.PQ 2]), sum([Standard.PQ 2]))

Regards,

Jagan.

[priyarane]

Hi Jagan,

Can you please brief of the expression,

what is Rowno() here.

[jsanchezh]

I think Rowno()=0 is the total line from the pivot table

[jagan]

Hi Priya,

For Total row the Rowno() returns 0, in this case we are using different expression.

Regards,

jagan.