7 Replies Latest reply on Dec 5, 2016 10:58 AM by Matthew Risley

    Pie Chart using 3 measures(A,B,C) all in multiple excel sheets

    Nik Rao

      Hi,

       

      I have three measures as shown below. I am able to generate a Pie chart using these without any problem.

      Pie example.JPG

      But the catch here is, this is "Sheet1" in excel and I have multiple sheets, say 4. All the sheets within one excel file.

       

      So I need to have the sheets as a single selector that drives the pie chart. The measures names and the metadata are exactly the same for all sheets

       

      This sounds really tricky. Could use all the help I can get here. Appreciate all the help and Thanks in advance.

       

      Regards,

      Nik