Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Sum({$+<Month = {"=Count({<Type>}DISTINCT If(Type = 'P', Type)) = 0"}, Type = {'SP'}>} Sp)
Dear Sunny,
Its Working Well,Thanks A lot For Your Help
Could Please Explain the Expression.
Once Again thank you So much.
hi Sunny,
Could you Please Explain Above Expression.
it will more helpful to me.
Thanks,
K.Ranjit.