Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a dashboard, in one object (Bar Chart), i need to see sales trend against customers for all years. For other Information in the dashboard Current Selection - 2012, is required.
For this i added alternate state (All Years) for that chart only.
Current Selection is - 2012.
After above settings the chart shows yearly sales trend for all customers for all years.
The issue is after this setting when i am selecting specified customer (within the dashboard), it is not impacting the chart, and it is still showing data for all customers all years. Though i need to see yearly trend for selected customers for all years.
Is there any other way that current selections along with alternate state selections can depict results in a chart?
Thanks
Shiv Sharma
May be you can upload your file or copy your expressions and an image of your model to see how do you have the relation with the calendar
I think something like this:
SUM({Group1<Year=$::Year>}Sales)
Hope that helps,
Aaron