item company1 company2 company3
price1 price2 price3 price1 price2 price3 price1 price2 price3
item1 10 40 50 50 30 90 50 90 40
item2 20 60 90 60 40 20 40 40 50
I have a pivot table to show exact data, similar to the table on the top. However, the ‘Value’ section automatically sums my field instead of just displaying the specific amounts for each field. Is it possible to remove the sum aggregation in the ‘Value’ section of the pivot table
item company1 company2 company3
price1 price2 price3 price1 price2 price3 price1 price2 price3
item1 10 40 50 50 30 90 50 90 40
item2 10 40 50 50 30 90 50 90 40
This is what my table look alike. The amount all same instead of specifics value.