Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table which contains one dimension: [Nickname]&[Mode].
Now I have an issue that when I open the page, I automatically set the month to the current running month. Now this filters out some of the dimensions, because they might not have data yet for the current month. How can I make the table not care about the month selection and always display all the available [Nickname]&[Model] dimensions? Thanks in advance.
// Tuomas
If the name of your month dimension is MyMonth then change your chart expressions to ignore selections in the MyMonth field. For example sum(Sales) would have to be changed to sum({< MyMonth= >}Sales). Change your chart expressions accordingly and don't use MyMonth, but the actual name of your month field.
Hi,
I have to achieve the same in a line chart but I have a drill group as a dimension in line chart i.e. Month>Day and I want to bypass both the field in the chart and its not working by doing the above mentioned set modifier. Any advise ?
Thanks
Taha
Also, I tried getcurrentfield() with if statement inside the set modifier but didn't work.