4 Replies Latest reply on Dec 12, 2019 4:39 PM by shuhei saito

    Coloured Current Month on Stacked Bar Not Working with Secondary Datasource

    Vanessa Gray

      Hello helpful people!

       

      Attached workbook

       

      I have a running sum over sales for a selected year.  I want to highlight the values as they occur in the "current month"  I have created a parameter to select the current month to make sure its working ...

      Worksheet titled "Working" shows the sales in December on top of the YTD to Nov - and it looks great. 

      But when I add the targets, see worksheet titled "Not Working" it only colours the WHOLE month incl. the YTD figures for sales.    see second image below

      The targets have to be the primary datasource because the targets are set at the start of the year and I want the chart to show all months and they fill up as the year progresses. 

      Sales only occur in the sales table as the operational data comes in.

       

      Can I colour the portion of the bar for a running sum within a secondary datasource

       

      Workings attached

       

      Help muchly appreciated