Skip to Content
0
Aug 01, 2016 at 11:08 AM

Waterfall Chart - Adding a dimension

29 Views

Hello,

We have a requirement to create a Waterfall Chart that initially contains 3 measures:

  • Our 2015 Qty Sold
  • 2016 Qty Sold v Previous Year Qty Sold Delta
  • 2016 Qty Sold

We have managed to achieve this as below:

Initial View:

We would like to give our users the options to add a dimension to this to further drill down the spread of the delta. The output we are looking for upon adding a dimension would look similar to the following:

2015 Qty and 2016 Qty would be anchored on the left and right, the delta would be broken down on the dimension the user has selected as above.

We haven't found a way to achieve this format yet, has anyone produced something similar before or can offer any help?

Thanks,

Ross.

Attachments

Capture.PNG (15.7 kB)
Capture3.PNG (15.5 kB)
Capture5.PNG (94.8 kB)