Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
The ask :
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.
maybe this:
Sum(sales)/Min(total <product> aggr(Sum(sales),product,position))
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 ) )
HI
this expression should work for you
sum(Sales)/aggr(nodistinct min( aggr( sum(Sales),Type)),Product)
Hi Vishal,
How about this.
Inc. Measure : Sum(Sales)/Min(total aggr(Sum(Sales),Product,Part))
Sample data:
Table Properties:
Output:
maybe this:
Sum(sales)/Min(total <product> aggr(Sum(sales),product,position))
Thanks a lot, have been breaking my head over it. Works perfectly.