2 Replies Latest reply: Jan 19, 2016 7:02 AM by Wolfgang Görbing RSS

    How to add a value for the difference to a previous time period to a bar chart?

      Hi, I'm using "Time" as a drilldown dimension consisting of the table fields "Year", "Month" and "Day". I have successfully created a bar chart that shows the measure "Sales" over the dimension "Time" and I am able to drill down in this chart to show the sales amont for all months of a selected year and all days of a selected month.

       

      Now I want to add the difference in sales between the previous time period and the current time period as a measure to the chart. When no selection is made, it should show the difference between the years, when a year is selected, it should show the difference between the months of the year and when a month is selected it should show the difference between the days of the month.

       

      How can I create a measure that shows the difference of the sales amount between the actual and the previous time period?