Grand totals with two different measures

One of my user raised a concern with Grand total functionality of Proclarity. He was trying to add values of two different measures (using Grand Totals on Rows) which you can see below. Now let us see if the what he was expecting and how Grand totals work here.
As per Proclarity functionality, Grand total and subtotal functions don’t add value of two measures on different customers or Products.Instead it adds a measures value for different time, product, customer etc. (Grand total don’t add two measures as you can see in the screen below from Adventure works example)

If you want to add these two measures, you need to make a calculated measures. The steps for the same is shown below:

1. Right click on any measures and select “New Measure”.

2. Select Custom formula and press next.

3. Select measures one by one as shown in the screen below and put a ‘+’ sign in between.

4. Change the name of the measure if needed. Click finish.
5. Now you can use this measure which gives you the summation of two measures.

Keep looking this space for more details on Gran Total functionality and many more....

Till then bbye...