Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist III

Avoiding alternate states

I have two charts the one is line chart with monthyear as dimension

and other is a bar chart with products as a dimension

and I want to have a year and month filter only for 2 chart and not for the line chart which is having monthyear as dimension

I am using alternate states but is there any other way to do this?

5 Replies
tresesco
MVP
MVP

Have you tried using Set Analysis? You could try like: Sum({<Year>} Sales) to avoid Year dimension selection.

Anil_Babu_Samineni

I believe this is the good option unless with in set analysis you can write identifier of Alternate states..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
gautik92
Specialist III
Specialist III
Author

can I do this without using alternate states

Anil_Babu_Samineni

If you look Treesesco answer it may helps you. You need to degrade the fields from Bar chart of 2 fields if you don't want to change from selection..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
gautik92
Specialist III
Specialist III
Author

in the first chart am using monthyear as dimension ignoring selections is not working