How to calculate Total upc sales within categoty

[Peony]

Hi all
I need to create a pivot table with a calculation where Sum(Sales) for UPC is divided by Sum(Sales) for particular category, this UPC is related

Test_Table:
LOAD * INLINE [
Category, UPC, Sales
Beverages, 123, 1500
Dairy, 987, 2300
Dairy, 456, 1200 ]; 

So 
For UPC 123 = 1500/1500
For UPC 987 = 2300/(2300+1200)
For UPC 456= 1200/(2300+1200)

This should be something like Sum(Sales)/Sum(Total Sales). But how to add an analysis part so that the category is also included?

[robert_mika · Accepted solution]

Try:

Sum(Sales) / Sum({<UPC=, Category=P(Category)>} Sales)

[Peony]

Hi @robert_mika  This is it! Thank you!