2 Replies Latest reply on Jun 20, 2018 9:34 AM by Mukesh Kumar

# Plot the difference in the measure based on two separate values of a dimension.

Hi All,

I want to plot the difference in budget amount [Measure] between various customer segments[dimension] over the time line.

Please see the attached excel for sample data and also the viz for better understanding.

Thanks in advance.

Mukesh

• ###### 1. Re: Plot the difference in the measure based on two separate values of a dimension.

Hi mukesh kumar,

Please  check the below,it will help you out.

You can download the workbook from the link.

Br,

Bharat

• ###### 2. Re: Plot the difference in the measure based on two separate values of a dimension.

Dear Bharat,

Thanks for the response.

But What I need is to be able to calculate and plot the difference in the budgeted values in segments over timeline( Quarterly)

For example, I want to calculate & Plot:

Quarterly Difference

QuarterDiff1(Corporate-Consumer)               =  Budgeted value of  Corporate segment (Q1,2010)     -    Budgeted value of  Consumer segment (Q1,2010)

=  152986 - 93022

= 59964

QuarterDiff2(Small Business- Home Office) =   Budgeted value of  Small Business (Q1,2010)     -    Budgeted value of  Home Office (Q1,2010)

= 70818  - 99054

= -28236

I want to plot "QuarterDiff1" ,"QuarterDiff2" on Rows, and Date on Column. in worksheet.

Thanks in advance.

Regards,

Mukesh Kumar