Proportion Query

[narayanamsn]

Hi,

I have a question on proportion.

Company	Levers	Value
a	Sales	2
a	Discounts	4
a	Expenses	10
b	Sales	12
b	Discounts	8
b	Expenses	9
c	Expenses	15

Need to calculate the below Parameter (what is the expression?)

Company	Metric
a	= Expenses of a / Expenses of c	=10/15
b	= Expenses of b / Expenses of c	=9/15 stalwar1‌

[sunny_talwar]

May be this

Dimension

Company

Expression

Sum({<Levers = {'Expenses'}>}Value)/Sum(TOTAL {<Levers = {'Expenses'}, Company = {'C'}>}Value)

[narayanamsn]

How to add any date filter if I have ..

Company	Levers	Value	Month
a	Sales	2	1
a	Discounts	4	1
a	Expenses	10	1
b	Sales	12	1
b	Discounts	8	1
b	Expenses	9	1
c	Expenses	15	1
a	Sales	10	2
a	Discounts	2	2
a	Expenses	4	2
b	Sales	15	2
b	Discounts	5	2
b	Expenses	8	2
c	Expenses	10	2

Company	Metric	Month 1	Month 2
a	= Expenses of a / Expenses of c	=10/15	=4/10
b	= Expenses of b / Expenses of c	=9/15	=8/10

[sunny_talwar · Accepted solution]

This

Dimension

Company

Month

Expression

Sum({<Levers = {'Expenses'}>}Value)/Sum(TOTAL <Month> {<Levers = {'Expenses'}, Company = {'C'}>}Value)