Hi Forum,

I'm handling quite big data through Power Query.

So, I want to use the data as background (i.e I don't want to load the data into a table in worksheet) to save space. (Excel worksheet with Power Query data load into a table would be >4MB larger).

I've inserted the Pivot Table using data model - ticks those item that I want to calculate further as percentage in new column. 

But, the Field list is greyed. I can't add the formula to calculate the new column.

This is my Dashboard Excel File

https://docs.google.com/spreadsheets/d/1RM5Bx-_nGdjOBLXXX9EbNANbrqqBvLPe/edit?usp=sharing&ouid=107899304830801301281&rtpof=true&sd=true

This is my source worksheet File (Data Table)

https://docs.google. com/spreadsheets/d/1dhAjSEg3O4u1CMHFCRgRcclt8CrrNR2G/edit?usp=sharing&ouid=107899304830801301281&rtpof=true&sd=true

Thanks