3 Replies Latest reply: Jun 7, 2016 5:39 AM by Николай Лешкевич RSS

    How can I create table with two different total by one dimension?

    Николай Лешкевич

      Hi,
      I have troubling with following table

      I need calculate total for period (January-June) for each year, in next month this period would be January-July and so on
      After that column I need to calculate common total. Is it real?

      Thanks in advance for any help with this!

      DimensionJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember

      Total

      Jan-June

      Total
      20141 799 5471 721 2402 093 0462 149 2501 522 0041 543 9251 703 2421 808 4872 168 3882 242 0772 306 3443 295 80710 829 05224 353 357
      20151 883 8721 967 7692 030 3531 869 6341 502 3361 467 1241 652 9681 712 5122 211 0502 403 8812 522 0713 288 68310 721 088 24 512 253
      20161 128 4101 675 0001 562 0042 009 2501 599 547164 0006 538 6646 538 664