Need Help In Expression

[kakaderanjit53]

Dear Expert,

        I have Following  Inline Table

Test:

Load * Inline [

Type,Sp,ExchangeCoe,Month

P,100,NSE,Jan

SP,200,BSE,Jan

P,300,BSE,Feb

SP,500,NSE,Feb

SP,600,BSE,Mar

];

after adding fields into table it showing like Sample.png

Please Find Actual and Expected images.

Here My Requirement is when i click on Type  SP  it is showing sales   500,200,600

like that if i click on Type  P i want to show  300,100,600

Note: if i click on Type P i want to Show 300,100 for Feb,Jan and

For March Month i want show 600

logic is if i click on Type P want to show sales 300,100, for March Month There is no Type P in this Case i want Show SP Sales As P Sales

Please Kindly Help Me

Thanks,

K.Ranjit.

stalwar1‌reddys310‌jagan‌stephanejanin‌

[sunny_talwar]

Try this

Sum({$+<Month = {"=Count({<Type>}DISTINCT If(Type = 'P', Type)) = 0"}, Type = {'SP'}>} Sp)

[kakaderanjit53]

Dear Sunny,

                 Its Working Well,Thanks A lot For Your Help

                Could Please Explain the Expression.

Once Again thank you So much.

[kakaderanjit53]

hi Sunny,

                  Could you Please Explain Above Expression.

                    it will more helpful to me.

Thanks,

K.Ranjit.