Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

divide 2 visualtisations

I have 2 slicers: one choosing the year and one choosing the month (or months). I have two results: the total of the year an the total of the selected month(s):

I have the turnover of year X

I have the turnover of Months A - B - .. (minimum 1 month to maximum 12 months)

 

How can I now: Divide both results / sum both results etc. So avoiding measures or calculated columns?

 

If I can not avoid measures or calculated columns, please explain me how I can resolve this? I have next data:

table : alle afleveringen

Columns in this table = year / month / turnover

 

thank you

 

No Replies