Christyxo, Yes, I'm doing what you had mentioned. I was hoping to not have to do the second aggregation piece and keep it to one analysis. Thanks for responding.

Thank you for your help. I will give this a try.

on second thought, maybe I didn't get it working :) I do a rank(cast( pongo_id as integer)) in my column formula. And this is the output. Confused as to why it goes from 1 to 9, then from 9 to 17, and so on ?!? I would expect the id to be 2 where Pongo ID = 67473, and id to be 3 where Pongo ID = 67472. Any more help is…

Thank you. Got it to work with ranking.

Thank you Gianni. Yes I know about conditional formatting and "Enable alternate styling". The Records IDs will not be sequential, first group of Record IDs may be 31456, 2nd group 31499, and 3rd group 31809, as an example. If they were sequential, it would be easier to do the coloring via conditional formatting....

Jerry, I got something to work with that last approach! I appreciate your diligence here. Much appreciated! Tom

Not giving correct results. Here are the 1st two rows of the Grand Total columns: I'm really struggling here. What did I do wrong?

I got the Name Totals and Grand Totals lines working and in their correct places on the pivot table. Only thing I can't get right is the pivot table Grand Totals % column on the right (right-most column). The Atts. and Cmps. are correct.

I realize that it seems redundant. Just know that I can also select individual weeks instead of "All Weeks". Probably should have mentioned that earlier, but didn't want to complicate matters.... I hope that makes it clear why I need the Name totals. I'll work on what you mentioned....

Massimo, How about if I do not permit the overlapping of the groups? Can I still use the unions and get the Grand Total %'s working correctly/ Thanks, Tom

Ultimately, I would like a "Grand Totals" for name="Jones" (and the other Names), for All Weeks and each Week Group. (you can see this in my original post). I would have to select "Column Totals" in the pivot table. And i would like a bottom line "Grand Totals" for each "Qtr". I was able to get that working thanks to your…

Jerry, I started with the All Weeks query (no unions) and the Grand Total %'s were correct. I added a union with GroupA and the Grand Total %'s are incorrect, as I suspected. I used the filter that you mentioned above. (table.Weeks IN (@{PVWeekGroupA}['@']{'week1','week2','week3'}) ). The percentage total for Week 1 (and…

Jerry, Think in terms of a football game for my example. There are 4 quarters per game, 1 game per week. In my example, week is the only element in a structured time dimension. Let me know if this is not clear. Tom

Jerry, This would be a 3-leg union. All Weeks w/ Grp A w/ Grp B. The "All Weeks" Grand Totals for Att. and Cmp. are correct, but the Grand Total % is incorrect every time. It seems to always take the % that is in the very first Att/Cmp/% group. In my example, it shows 50% for Jones, 85% for Smith, and 67% for Green. The…