Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have the following pivot table.
In which i want to differentiate each group of rows, may be by changing the background color of each set of rows alternatively.
Project Number | Project Name | Year - Month | Res | Bud | Sch | Qua |
E-2012-007 | A | 2012-08 | 1 | 1 | 1 | 1 |
2012-09 | 1 | 1 | 1 | 1 | ||
2012-10 | 1 | 1 | 1 | 1 | ||
2012-11 | 1 | 1 | 1 | 1 | ||
2012-12 | 1 | 1 | 1 | 1 | ||
2013-01 | 1 | 1 | 1 | 1 | ||
2013-02 | 3 | 3 | 3 | 2 | ||
2013-03 | 3 | 3 | 3 | 2 | ||
2013-04 | 3 | 3 | 3 | 2 | ||
E-N-2013-002 | B | 2012-10 | 1 | 1 | 1 | 1 |
2012-11 | 1 | 1 | 1 | 1 | ||
2012-12 | 1 | 1 | 1 | 1 | ||
2013-01 | 1 | 1 | 1 | 1 | ||
2013-02 | 1 | 1 | 1 | 1 | ||
2013-03 | 1 | 1 | 1 | 1 | ||
2013-04 | 1 | 1 | 1 | 1 | ||
G-2012-015 | C | 2012-08 | 2 | 2 | 2 | 3 |
2012-09 | 2 | 2 | 3 | 3 | ||
2012-10 | 2 | 2 | 3 | 2 | ||
2012-11 | 2 | 2 | 2 | 2 | ||
2012-12 | 2 | 2 | 2 | 2 | ||
2013-01 | 2 | 3 | 2 | 2 | ||
2013-02 | 2 | 3 | 2 | 2 | ||
2013-03 | 2 | 2 | 2 | 2 |
Desired O/p:
Can Any one suggest a solution?
Leo
Here it is ...
This wouldn't work for me, either, but it may be down to the limiting of dimensions through set analysis in the expressions, so I've come up with another solution (seems to work 99% of the time, anyhow) using the following idea (I'm using some user log data, but it should be simple to amend to suit your data) ...
Create a variable to concatenate your distinct dimension values, here I also add in my set analysis from the expression to limit the list as the Pivot Table will do ...
=concat({<[Session Start] = {">=$(DocDatesFrom)<=$(DocDatesTo)"}>} total distinct [Identifying user],',',[Identifying user])
... then use this expression to split the string at the relevant place and count the preceding commas (or whatever delimiter you are using) ...
=if(even(substringcount(subfield(vUsers,[Identifying user],1),',')),LightGray(200),Yellow(100))
I'm guessing the sort order of the Pivot table will be important too.
flipside
Hi,
Thanx for the sample. this works for most of the cases, but if i have to apply any filters on the table than the alternate colring is not working properly. Refer to the image attached.
As you can see the A & C are both in red. But that should happen.
Any solution for this?
Leo
See attached qvw.
Hi Gysbert,
I also have the same requirement discussed in this post and tried to implement the way you did in the sample application comm81789.qvw .
Unfortunately it is not working for me properly. I have attached my sample application .Please help me where i am going wrong
Many thanks for your help and time.
Regards
Murali Krishna