2 Replies Latest reply on Apr 30, 2014 12:23 PM by Aaron Clancy

How to create calculations "daily profit/Monthly Sales"

kamal rajput Apr 30, 2014 12:13 PM

Hi ,

I have a report with two measures profit and sales. I am displaying profit by month and date. I also want to display one more measure which is basically daily profit / monthly sales. Can you please let me know how to do calculate it daily profit/Monthly Sales in same report.

PFA the sample report.

Thank you in Advance for all help that you provide to me.

Regards,

Kamal

Calculations.twbx 503.5 KB

1. Re: How to create calculations "daily profit/Monthly Sales"

Aaron Clancy Apr 30, 2014 12:22 PM (in response to kamal rajput)

sum([profit])/window_sum(sum([Sales])

compute using: Advanced
At the level of Deepest.
restart every month.
Like Show 0 Likes(0)

Actions
2. Re: How to create calculations "daily profit/Monthly Sales"

Aaron Clancy Apr 30, 2014 12:23 PM (in response to Aaron Clancy)

Screenshot of result:
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How to create calculations "daily profit/Monthly Sales"

1. Re: How to create calculations "daily profit/Monthly Sales"

2. Re: How to create calculations "daily profit/Monthly Sales"

Actions

More Like This