You have to aggregate fields/measures in your IF..ELSE statement like ATTR([From_Segment]) and SUM([net_usd_equiy])
Give a try and let us know if this work.
1 of 1 people found this helpful
Enclose from segment with ATTR if it is a Dimension
net_usd_equity - enclose with SUM if its not already aggreated
this will solve your problem
Hope this helps
Plz mark this answer as correct or helpful to close the thread
now this calculation is working fine but the problem is we are using this agg calculation measure(report measure) for sorting purpose, as we know for aggregated measure can't be include for sorting drop down option. How to achieve this ?
Naveen B ned your suggestion.
Place the calculated value at the first in the columns or rows based on the value it will sort
Could you please attach a workbook to help you further
Thanks for reply , as data is highly sensitive so can't attach a workbook.Do you have skype ?
If the data is sensitive, Can you cook up some similar sample data with same data types.. You can replicate the solution later in your original workbook.