Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We are having a requirement to show alternate colors in Pivot Table based on Submission ID.
If Submission ID "2" is given blue then next Submission ID "3" should "yellow" then again for 5 it should be blue and for 7 it should be yellow.
I have attached a sample QVW with this. Please let me know if you need any more information.
Thanks,
Sijo
Hi Sijo,
how is you color calculated? ...if Submission ID "2" is blue... Submission ID "2" is blue, because ...
BR
M
Stick this into the "Background Color" definitions for just the expression or expression + dimension if needed:
if(Match([Submission ID],'2','5'), LightBlue(100), Yellow())
You can change the alpha value of the blue, or enter RGB codes if that's more what you want. If you go any darker with the blue I'd also recommend changing the text colour using the same expression to White().
Try this in your background expression.
IF(Even(RowNo(TOTAL)),Yellow(),Blue())
thanks,
Rajesh Vaswani
Hi Sijo,
see the background-Color definition in the sample-file.
The Match-function from Aaron is the more elegant solution.
Regards
Martin
The value's we put 2,5,7 just dummy values. It can be any values from 1..10000.
We need to color when the submission changes from the previous one.
Thanks,
Sijo
Fine, but very first color in your order is based on some calculation? Like if amount for Submission ID2 is under 300, get blue?
So its alternate colouring right?
Hi,
If its about the assigning the colour on the basis of Odd and Even Submission IDs then;
Expression->Background Colour -> if(Even(SubmissionID),Blue(),Yellow())
Hope it helps !
Cheers !
yes