Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 khasimvali85
		
			khasimvali85
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Can anybody give idea about calculate dimensions
how to create calculated dimension with date field like given below
i have date field like
date
jan-14, feb-14, mar-14 up to current month aug-15
my requirement is in bar chart dimensions like given attachment
current month , previous month and last year current month
Regards,
khasim.
 
					
				
		
 jonathandienst
		
			jonathandienst
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		
Khasimvali85 wrote:
already i have date field date or Month Year
i need condition in dimension using month year.
this one also helpful but not my exact output
This was a sample for you to adapt to your needs
 khasimvali85
		
			khasimvali85
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Thanks for reply
can you give example file for this?
 khasimvali85
		
			khasimvali85
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HI,
You created in script level but i need in designing level
already i am having the fields like date field and month year field and value fields
just i need in dimension i don't want all date fields
i need only as per given data Last Year Current Month(July-14) , Current Year Previous month(June-15) and Current year current Month(July-15)
 antoniotiman
		
			antoniotiman
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		See attachment.
Regards,
Antonio
 Kushal_Chawda
		
			Kushal_Chawda
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		i think what I have done is dynamic. You can select the any month.. it will automatically change the dimension.
