I have a pivot based on raw data where each line is a person and their characteristics.
What I'd want to achieve: I'd like the percentage of a value depending on various subgroups and locations. I want something like a calculated field. IE: =Sum of Laptop/Count of Index. That doesn't seem to work. Of tried every iteration of the "Summarize Data by" menu.
I feel like I'm missing something fundamental here.
What I'd want to achieve: I'd like the percentage of a value depending on various subgroups and locations. I want something like a calculated field. IE: =Sum of Laptop/Count of Index. That doesn't seem to work. Of tried every iteration of the "Summarize Data by" menu.
I feel like I'm missing something fundamental here.
