I am new to Pivot Tables. I need to export a BO report into excel and it should have pivot cabability. The data that I have in the report is
Org Second & Org Third are on the page level. Act_code, Prg_code are on the row level. Hours_charged is on the data level. I need to also show a distinct count of employees for each Org second and if you expand it and select the Org third then it should reflect the changes. I am getting the correct value for the hours_charged, but I am not getting it for Count of employees. I need a distinct count group by Org second. Any help will be appreciated.