Pivot Table Substraction

[#1]

Please find the attached .QVW file.

Query1:-

  I want to remove extra space from Market Value and Demo Value (Pivot Tables) , how can I remove that ?

  Query2:-

  I want to subtract Market Value (300) from Demo Value(1700) i.e. 1700-300=1400 and should display this subtraction below Total as

Net Assets** ("Demo Value-Market Value")=1400

Please help.

[priyasawant]

You can directly write it in the backend

Load *,

Demo Value-Market Value as Net Assets;

[Anil_Babu_Samineni]

First One this?

Second one where you want to see those?

[#4]

I want to display subtraction(1400-300)  below Total value.

[Anil_Babu_Samineni]

That's fine where you want to show this? KPI ??

If KPI

=Sum({<Level1 -= {'Cash'}>} [Market Value]) - Sum({<Level1 = {'Cash'}>} [Market Value])

[surendraj]

Please Find the attached one.

May be  this help you!!

[#7]

Need to display like below.

[Anil_Babu_Samineni · Accepted solution]

Do you like this Approach

OR

[#9]

Thanks Anil for the reply. I am looking for 2nd option which you shown above and m looking for the same.

Please explain below which you wrote in expression.

Sum({<Level1 -= {'Cash'}>}[Market Value])-Sum({<Level1 = {'Cash'}>}[Market Value])

[Anil_Babu_Samineni]

Sum the [Market Value] where Level1 is not the Cash(Means Remaining) Minus Sum the [Market Value] Where Level1 is Cash(Only Cash)

In fact, I would love to go first option instead of Second one due to moving issue if AJAX Client

I assume, You are happy with that. I would request you to close this thread by marking Help full and Correct Answer so that next lander may understand at a moment