5 Replies Latest reply: Apr 9, 2018 8:18 AM by vishal raina

# Aggregation Table

Hi Community members,

Need urgent help on the below.

I have to create a table in which i need division of some aggregated columns.

 Product Metric Front Back Side 1 a Sales 5254.5 2456.571429 2017.928571 2 a Inc 260.39% 121.74% 100.00%

We have 2 dimensions - one is the Product (a) and the other being the product position (front, back , side)

I have the sum of sales for the product "a" over the product positions(front, back , side) as given in row 1.

I want to find out the percentage as in row 2 which is sales /min(sales) for each cell. Denominator would be Min sales value across product positions per product (from row 1) and the respective sum of sales would be the numerator.

Ex. 260.39% =5254.5/2017.92, 2017.92 being the min sales.

Note : Table format isn't imp, just need a way to form a similar value table.

• ###### Re: Aggregation Table

could you provide a sample app with mock data ?

however maybe try this:

dimension: position, product

measure for Inc :

sum(sales)/min( aggr( sum(sales), product ) )

• ###### Re: Aggregation Table

HI

this expression should work for you

sum(Sales)/aggr(nodistinct min( aggr( sum(Sales),Type)),Product)

• ###### Re: Aggregation Table

Hi Vishal,

Inc. Measure : Sum(Sales)/Min(total aggr(Sum(Sales),Product,Part))

Sample data:

Table Properties:

Output:

• ###### Re: Aggregation Table

maybe this:

Sum(sales)/Min(total <product> aggr(Sum(sales),product,position))

• ###### Re: Aggregation Table

Thanks a lot, have been breaking my head over it. Works perfectly.