Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write the following expression :
In Dimension :
=if(Measure='ORDERS' AND Accuracy='ARITH - 1 month' AND [Report Months]='12' AND [Fiscal Month]= AND [Fiscal Year]=,[Product/Code],Null())
Note :
Measure='ORDERS' AND Accuracy='ARITH - 1 month' AND [Report Months]='12'
and [Fiscal Month] and [Fiscal Year] can be anything .
I need to select the product which fullfill the : Measure='ORDERS' AND Accuracy='ARITH - 1 month' AND [Report Months]='12'
I need to pull the report who fulfill the condition
Rather than using a calculated dimension, put those filters in the table/chart expressions:
{<Measure={'ORDERS'} AND Accuracy={'ARITH - 1 month'} AND [Report Months]={12}>}
This will usually perform better than a calculated dimension.
Sorry, it's unclear to me what you are trying to achieve, especially it's hard to understand without knowing your data model.
If the user selects the values like shown above, this should already filter the data in your data model and influence any exiting report. Maybe you don't need to create a calculated dimension at all.
Put the conditions in the set expression rather and try like:
Dim: [Product/Code]
Exp: Sum({<Measure={ORDERS}, Accuracy={'ARITH -1 month'},[Report Months]={12}>} AmountField)
Adjust your expression(aggregation function and measure) accordingly.
Rather than using a calculated dimension, put those filters in the table/chart expressions:
{<Measure={'ORDERS'} AND Accuracy={'ARITH - 1 month'} AND [Report Months]={12}>}
This will usually perform better than a calculated dimension.