Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, is it possible to have multiple charts on a tab and have the max quarter (most recent quarter) show up in a different color
For example: 2010 Q1 -2011 Q4 (all bar charts would show up in blue) and then 2012 Q1 would be in green?
Thank you
Do you also have a Field: Quarter?
I have a field called Fiscal Quarter and Year ex. 2012 Q1 and a field called Fiscal Year ex. 2012
Ok, what happens if you use:
if(Quarter =Max(Total Quarter), blue())
Where the green Quarter is the fieldname of your Quarter
?
It still doesn't change the color for me :<
Can you share your document here, then I will have a look.
Attached is an example copy of what I'm trying to do
Hi G.
I found what the problem is. Your formula is right.
But your field is not a number field
I tried this:
=if([Fiscal Year] =Max(Total [Fiscal Year]), red())
And that worked.
Try this in your load script
purgechar ( [Fiscal Quarter and Year],'Q' ) as Quarter
And use this field
This will drop the Q from the field so you can count with it.