6 Replies Latest reply: Jun 11, 2015 11:57 AM by Sébastien Fatoux RSS

    NPrinting Excel reporting with a loop on several sheet

    Sébastien Fatoux

      Hi,

       

      I have three sheet "Country - Actual", "Country - Previous", "Country - Delta" in my Excel template.

       

      I want to loop on the Country dimension to generate a report with these sheets (in this order) :
      "Italy - Actual", "Italy - Previous", "Italy - Delta", "France - Actual", "France - Previous", "France - Delta", ...

       

      At this time, I added Coutry dimension as Page, but I get the following resut:

      "Italy - Actual", "France - Actual", ...    , "Italy - Previous", "France - Previous", ...    , "Italy - Delta", "France - Delta", ...

       

      Is it possible to get the result that I want ?

       

      Many thanks,

       

      Sébastien