Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have built an app to calculate the cash call of two partners Barry and Young on a particular location for a year ( I will be looking at more than one year later from 1999 -2003).
For year 1999.
I have managed to develop the app (see attached... dummy.qvw)
I 'm using a filter called partner.
On columns barry over/under cash call and young over/under cash call.. Is it possible that whenever I choose barry, only barry transaction that will be visible in both the chart and table?
See attached for clarity.
Regards
Here is the app
Thanks
I did not found your attached but in the expression of the chart you can try to hard code this
Ex:-
Sum( {<Personname = {'barry '} >} Sales)
Please find the attached file ....
You can have one single expression which is:
=Sum ([PER NGN])
And then you add Partner as an additional dimension. Then you will get what you want.
See attached modified app.
Is that you looking for by adding SET expression {<Partner = {'Barry'}>} .
See attached.
May be this
=Sum ({$<Equity = {'55'}, Partner *= {'Barry'}>+<Equity = {'45'}, Partner *= {'Young'}>} [PER NGN])
With 2 dimensions
1) Location
2) Partner
Thank you Sunny..
May I didn't ask the question well,
my interest is on
Columns :Over/Under Cash Call (Young ) and Over/Under Cash Call (Barry )
Chart : cash call performance
Is it possible that if I use the partner filter, if I choose Young, Young's value appears and Barry value is removed ? (look at cash call figure chart)
Thanks
See if the attach is what you want
We are making progress brother.
Can we do the same for the tables?
For columns : Columns :Over/Under Cash Call (Young ) and Over/Under Cash Call (Barry ) on the table.
Thanks