Set Analysis in Pivot Table

[ruma_barman]

There is a dimension named Revenue and a dimension named Month Name from master calender and I have to show

in a pivot table Month Name as the dimension and expression is sum of revenue for the corresponding month minus sum of revenue of the previous month.

Example: For Jan 2017 ,it should show sum of revenue of Jan 2017 minus sum of revenue of Dec 2016 in the table.

Refer screenshot.

[Peter_Cammaert]

That depends on your table type and the number of dimensions you are using. Try it and see what you get.

Maybe it's better for you to upload your document or a reduced/scrambled demo copy of it. Every suggestion we make has been tested and works for us in specific circumstances, but they fail to work for you because of an unknown context. The discussion is getting long drawn-out for something that should be pretty simple to solve.