Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to freeze value in fields (All Member, Total Buy) when I select data from list box.
Before
Brunch | All Member | Total Buy | Member got Premium | Total buy whem Member got Premium |
A | 17,932 | 176,097,832 | 13,368 | 102,256,280 |
B | 13,305 | 146,108,394 | 9,626 | 81,355,025 |
C | 16,736 | 145,349,116 | 11,865 | 79,188,964 |
D | 10,830 | 109,478,043 | 7,496 | 60,535,767 |
Total | 58,803 | 577,033,385 | 42,355 | 323,336,036 |
After
Brunch | All Member | Total Buy | Member got Premium | Total buy whem Member got Premium |
A | 17,932 | 176,097,832 | 10,618 | 73,152,506 |
B | 13,305 | 146,108,394 | 7,317 | 52,065,784 |
C | 16,736 | 145,349,116 | 9,330 | 54,765,378 |
D | 10,830 | 109,478,043 | 5,578 | 40,548,605 |
Total | 58,803 | 577,033,385 | 32,843 | 220,532,273 |
May be,
in 1 And 2 expression Write like:
= count({<year=,product=>}distinct membercode)
Total Buy = sum({<year=,product=>}total_buy)
its should work plss try
Sachin
Didn't clear to me, Can you explain bit more?
Thank you for your question
I have data 4 Columns
1. All Member = count(distinct membercode)
2. Total Buy = sum(total_buy)
3. Member Got Premium = Count(Distinct {$<Condition= {'Premium'}>} membercode)
4. Total buy when Member got Premium= sum({$<Condition= {'Premium'}>} total_buy)
When I choose data from list box (Sample Year, Product), I don't want (1) and (2) to change, i need to freeze.
yu have to add {<[Sample Year]=,Product=>} in your table expression..
Like this sample expression-> =Sum({<[Social Media]>}[No of Feedback])
Whatever your expression may be, add those exceptions in it.
May be,
in 1 And 2 expression Write like:
= count({<year=,product=>}distinct membercode)
Total Buy = sum({<year=,product=>}total_buy)
its should work plss try
Sachin
Hi,
Whenever u don't don't want some thing should not b effected based on some selection above said is the syntax.
Sachin
Hi,
If both are dimensions then use set analysis:
=Sum({<All Member=, Total Buy=>}Member got Premium)