How to freeze value in table when select other data from list box?

[panwipa2528]

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

[Anil_Babu_Samineni]

Didn't clear to me, Can you explain bit more?

[panwipa2528]

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.

[#4]

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.

[sdmech81 · Accepted solution]

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

[sdmech81]

Hi,

Whenever u don't don't want some thing should not b effected based on some selection above said is the syntax.

Sachin

[vardhancse]

Hi,

If both are dimensions then use set analysis:

=Sum({<All Member=, Total Buy=>}Member got Premium)