Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 yipchunyu
		
			yipchunyu
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I created a master calendar and setup some variable which prepared for using point in time reporting 
PeriodID = {$(=Max(PeriodID) – 12)}, Year = , Quarter = , Month = , Period =
QuarterID = {$(=Max(QuarterID) – 4)}, Year = , Quarter = , Month = , Period =
It works when I use it in measure, like below:
=Sum(${<=$(vSetPreviousQuarter)>} [SALES_USD])
However, I want to use the variable in chart as dimension.
In other words, is it possible to make
Current YTD vs LY YTD in the x-axis of a bar chart?
 Taoufiq_Zarra
		
			Taoufiq_Zarra
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you can fill nothing in dimension and leave the expressions with these values!
if not the expressions in dimension without aggr , I don't see very well
 yipchunyu
		
			yipchunyu
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		sorry, so how can i create a dimension
Current YTD vs LY YTD?
 Taoufiq_Zarra
		
			Taoufiq_Zarra
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		can you share a sample data ?
