I have a large dataset I am trying to analyse and I think I'm close but I can't quite figure out the last bit.
The big data set has three columns: location, type and value. I want to be able to analyse the distribution of values for a given location and type. I'm trying to do it using a pivot table.
I can build a pivot table that will filter for location and type. I can get it to give me each of the unique values in a column. But, all of the values that appear more than once disappear. Because what I am ultimately trying to do is to generate a distribution, that is no good to me - it matters how many entries there are for each unique value.