Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Do you like this Approach
OR
You can directly write it in the backend
Load *,
Demo Value-Market Value as Net Assets;
First One this?
Second one where you want to see those?
I want to display subtraction(1400-300) below Total value.
That's fine where you want to show this? KPI ??
If KPI
=Sum({<Level1 -= {'Cash'}>} [Market Value]) - Sum({<Level1 = {'Cash'}>} [Market Value])
Please Find the attached one.
May be this help you!!
Need to display like below.
Do you like this Approach
OR
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])
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