Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I create bar chart with 2 measure and one dimension - Year.
I want to filter in the dimension (not in the measure) so it will bring me only the max & min Year.
Any Idea?
Thank's!!
create 2 variables
vMinYear = Min(TOTAL Year)
vMaxYear = Max(TOTAL Year)
Change expression to, for example
=SUM( {< Year = {$(vMinYear),$(vMaxYear)} >} Sales)
create 2 variables
vMinYear = Min(TOTAL Year)
vMaxYear = Max(TOTAL Year)
Change expression to, for example
=SUM( {< Year = {$(vMinYear),$(vMaxYear)} >} Sales)