Product wise Total

[#1]

Dear All

I need help on below Requirement:

Any help would be appreciated.

Regards

ERic

[PrashantSangle]

Hi,

sum(Value)/sum(Total<Product> Value)

Regards

[Anonymous]

Hi Eric,

Create Straight Table

Dimension : Product

Expression : Sum(Value)/Sum(TOTAL Value)

Hope it helps!!

[susovan]

Hi Eric,

Try this attachment,

[susovan]

I have used this below expression for Logic:

if(Product='CAR',Sum({<Product={'CAR'}>}Value)&'/'&Sum(TOTAL{<Product={'CAR'}>}Value),

if(Product='TEMPO',Sum({<Product={'TEMPO'}>}Value)&'/'&Sum(TOTAL{<Product={'TEMPO'}>}Value),

if(Product='TRUCK',Sum({<Product={'TRUCK'}>}Value)&'/'&Sum(TOTAL{<Product={'TRUCK'}>}Value),

if(Product='BIKE',Sum({<Product={'BIKE'}>}Value)&'/'&Sum(TOTAL{<Product={'BIKE'}>}Value)))))

The expression of Desired Result:

if(Product='CAR',Sum({<Product={'CAR'}>}Value)/Sum(TOTAL{<Product={'CAR'}>}Value),

if(Product='TEMPO',Sum({<Product={'TEMPO'}>}Value)/Sum(TOTAL{<Product={'TEMPO'}>}Value),

if(Product='TRUCK',Sum({<Product={'TRUCK'}>}Value)/Sum(TOTAL{<Product={'TRUCK'}>}Value),

if(Product='BIKE',Sum({<Product={'BIKE'}>}Value)/Sum(TOTAL{<Product={'BIKE'}>}Value)))))

[PrashantSangle]

Hi,

what is your expression if you have 100 different of products???

Regards

[susovan]

Hi Max,

Thanks for your reply.

According to my expression it will be huge.

[#8]

Thank You Sir.

Can we do it from Backend Script using Rangesum or any other function.

[tyagishaila]

Sum(Value)/ Sum(Total <Product> Value)

[PrashantSangle]

Hi,

I just want to point out there is limitation with if - else so avoid it if you can.

Regards