Hey guys, hoping you can help me. I'm working on some reporting that is based off a pivot table and am trying to use a CTG (contribution to growth) metric. The formula for this metric is (TY-LY Sales)/LY Sales. My pivot table is organized by Team Name, League Name, and then Sales.
The problem I'm running into is that the bottom portion of the formula needs to be based on the full league sales. Is there a formula I can use that would ignore the team sales portion and just give me the total for the entire league? So for example...
Say I filter to NFL, and I have TY and LY sales for all teams going all the way down the pivot table. I want to see TY and LY sales for each team and then be able to return next to the team sales columns, the total sales for NFL so that I can use this in a calculated field.
I know this is complicated and hard to explain but let me know if you have any questions!
The problem I'm running into is that the bottom portion of the formula needs to be based on the full league sales. Is there a formula I can use that would ignore the team sales portion and just give me the total for the entire league? So for example...
Say I filter to NFL, and I have TY and LY sales for all teams going all the way down the pivot table. I want to see TY and LY sales for each team and then be able to return next to the team sales columns, the total sales for NFL so that I can use this in a calculated field.
I know this is complicated and hard to explain but let me know if you have any questions!
