Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to display a weekly sales and a year to date charts on the same view. In the weekly sales chart I always display one week at a time, but the ytd chart should always show the ytd sales regardless of the chosen week. Any ideas on how to implement this? thanks.
We can use set analysis or by using conditional flags
1 in above expression will use full set of data disregarding user selections.
For above expression to work, you need to have flags on date dimension created during document load. In our case _CYTD_Flag refers to all days in current year until today.
We can use set analysis or by using conditional flags
1 in above expression will use full set of data disregarding user selections.
For above expression to work, you need to have flags on date dimension created during document load. In our case _CYTD_Flag refers to all days in current year until today.
Thank you. I did some changes using your guidelines and it works