Hi Folks,
We are having more than 20 Brands in the report but here the user requirement is don't want to show the particular Brand values in that report so for example the brand name is like XXX but when they select the Brand in the Brand filter, the brand values should show in the report.
I hope that you can understand, telling again shortly. Do not show the particular Brand in the report but user select the brand manually using Brand filter, there the Brand value need to be show in the report.
I had tried a lot but if statement is working but else statement is not working, can you please assist for this issue. Really appreciate your helps!
The expression is:
=if (([Brand Group 1]='XXX',
((sum({$<Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Month={'*'},Calendar_Month = {'<=$(=max(Calendar_Month))'},Day_of_Week=>}Sales_Value))/1000)
/
count(DISTINCT{$<Month={'*'},Calendar_Month = {'<=$(=max(Calendar_Month))'}>}Month)
)
else(
((sum({$<Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Month={'*'},[Brand Group]=,Calendar_Month = {'<=$(=max(Calendar_Month))'},Day_of_Week=>}Sales_Value))/1000)
/
count(DISTINCT{$<Month={'*'},Calendar_Month = {'<=$(=max(Calendar_Month))'}>}Month)))
