Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Trying to write a formula
Could you correct this?
if(GetSelectedCount({<[Product Sub Group]>}={'Cheese'}>}[Sales]))
I only want the chart to populate if cheese is selected
Thankyou
Okay the expression is correct however it still does not work how it is intended to
Do i put the following expression in the calulated condition? or ad the dimension or expression??
Let me clarify i want to chart to show me sales and to populate only when i select the value cheese from a filter pane
you have to set a calculation condition as below under Add-ons->Data handling.
if( [Product Sub Group] = 'Cheese', -1, 0 )
with this condition your chart object will be filled only if you select the value 'Cheese' in the [Product Sub Group] field.
Did you check with chart properties ?
not working
please send a screenshot in order to see what are your current selections.
How about this
=If(GetSelectedCount([Product Sub Group]) > 0, Sum({<[Product Sub Group] *= {'Cheese'}>}[Sales Amount]))
Hi Sunny
This is what im getting
Can you post the image of the expression... as all I see is the chart... not sure if you use the expression correctly or not
let me see your object calculation condition.
=If(GetSelectedCount([Product Sub Group]) > 0, Sum({<[Product Sub Group] *= {'Cheese'}>}[Sales Amount]))