6 Replies Latest reply: Jun 17, 2014 4:20 PM by Erik Furlanis RSS

    how to correctly display totals which are contained in the datasource

      I have a source table which looks somehow like this

       

      regionstatusData
      Northon100
      Northoff200
      Weston50
      Westoff300
      Southon400
      Southoff210
      TOTon520
      TOToff490

       

      As you can see my data is split by regions and in the data table itself I have the totals.

      This because data is somehow overlapping between regions, so if I would exclude the TOT entries, I would come up with wrong total values.I could create four different charts with set analysis, but for real estate space issues, I would like to have this info in one chart.

       

      If I create this single chart with <region> and <status> as dimensions and sum(data) as expression, I have the problem that if the user does not select anything in <region>, the data which is shown is highly irrealistic.

      Is there a way to have a sort of set analysis, which is setting the <region> dimension to TOT, but still let users select either North, West or South?

      thanks!