Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Underneath the image , you see a chart with dimension StoreCode and Month. In the chart Average orders amount
i only want to show the used expression for only the storecode WSDP and WSBK. in the image below you see irrelevant stores....
How can i fix this? Thanks!
Greets,
Rega
May be use a calculated dimension here:
If(Match(StoreCode, 'WSDP', 'WSBK'), StoreCode)
and select 'Suppress When Value Is Null' on the dimensions tab
May be use a calculated dimension here:
If(Match(StoreCode, 'WSDP', 'WSBK'), StoreCode)
and select 'Suppress When Value Is Null' on the dimensions tab
Alternatively you can also use a set analysis in your expression. For example your expression was Sum(Sales), then change it to -> Sum({<StoreCode = {'WSDP', 'WSBK'}>} Sales)
I would suggest this approach, unless there is a very specific reason to use calculated dimension.
Hey Sunny T,
How can i let the chart show "0" or zero sales ( for example some stores had €0 sales) but still i want to show this in a chart.
Which parameters /settings should i do?
On the presentation tab -> uncheck 'Suppress Zero Values'