Forum Discussion

sraj's avatar
sraj
Responsive Resident
5 years ago
Solved

multiple tab in excel as source

Hi Everyone,

 

I have an excel spreadsheet with several tabs which is on one drive and has to be used as it is.  

 

First I had to show the Percentage based on the sum of Completed/ sum of Enrolled, which is on one tab of the excel sheet

Division Percent Complete = SUM([Completed]) / SUM(Leaderboard[Enrolled Training])
 
Now I am required to show Division Percent complete of only who passed and the Passed field that is in the other tab of the excel sheet For e.g. sum of Completed/ sum of Enrolled if they Passed
 
Can someone please advise on how I can acheive this?  
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi sraj ,

     

    To make this work you need to create a table for each of the tabs in your excel spreasheet so you need to have one table for the enorrled and another for the passed.

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi sraj ,

     

    To make this work you need to create a table for each of the tabs in your excel spreasheet so you need to have one table for the enorrled and another for the passed.