Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have an equation where Sales of shop = (A+b)/C
how can i get the percentage of the sales of each shop using the above equation ?
Can you share a sample app and expected output you are looking for?
Can u elaborate it more
go to number tab and enable the percentage option for that expression
Can you say it little bit clear??
This is my purely guess iam not sure whether is this your requirement
dimension : shop names
expression: ((sum({<fieldname={'A'}>}sales) + sum({<fieldname={'B'}>}sales) )/ sum({<fieldname={'C'}>}sales))*100
Your requirements are a little vague, but lets assume that you want % sales by shop in a table / chart and A, b, C are fields in your data model:
Use shop (name / code or ID number) as the dimension (lets assume ShopName).
Use the expression
=Sum(Aggr((Sum(A) + Sum(b)) / Sum(C), ShopName)) / Sum(TOTAL Aggr((Sum(A) + Sum(b)) / Sum(C), ShopName))
Adjust the field names to your requirements.
If everything is well associated then:
Sum(A)+Sum(B)/Sum(C)
A,B,C are ur attributes..