I have data in my pivot table, and at the filters section I have state.
For Example, I have the State of Alabama selected in the pivot table filter so I'm only looking at only Alabama.
Say my data has loss, premium, and a pivot table calculated loss ratio.
The data is simple for this example. I have group A, group B, and grand total, so 3 rows of loss, premium, and a loss ratio.
Outside of the pivot table, I have a comparison. I divide the Group A loss ratio by the total loss ratio.
Is it possible to use the excel table function to look at what this is for all states? I'm talking about the function that comes from the what-if analysis, then data table and uses an array.
I'm all ready confident that all states have both group A and B, and premiums and losses in groups A and B, so there shouldn't be any errors.
Is it possible to use the data function to accomplish this?
Cheers,
Gareth Keenan
For Example, I have the State of Alabama selected in the pivot table filter so I'm only looking at only Alabama.
Say my data has loss, premium, and a pivot table calculated loss ratio.
The data is simple for this example. I have group A, group B, and grand total, so 3 rows of loss, premium, and a loss ratio.
Outside of the pivot table, I have a comparison. I divide the Group A loss ratio by the total loss ratio.
Is it possible to use the excel table function to look at what this is for all states? I'm talking about the function that comes from the what-if analysis, then data table and uses an array.
I'm all ready confident that all states have both group A and B, and premiums and losses in groups A and B, so there shouldn't be any errors.
Is it possible to use the data function to accomplish this?
Cheers,
Gareth Keenan
Excel - data table off pivot filter?
0 commentaires:
Enregistrer un commentaire