In a pivot table you are able to double-click on a cell and it will show you the raw data rows that makes up the given value. I am wanting to show data like this based on a formula I have created. Is this possible.
Formula:
=IF(CP!$C$16="X",SUM(COUNTIFS(Data!$A:$A,CP!J2,Data!$H:$H,"PS",Data!$X:$X,"<>Planned Activities",Data!$R:$R,CP!$B$16)),0)
My value here is 44 in cell C21. Is there a way to either click on the cell to show the raw data? What is my best option here?
Formula:
=IF(CP!$C$16="X",SUM(COUNTIFS(Data!$A:$A,CP!J2,Data!$H:$H,"PS",Data!$X:$X,"<>Planned Activities",Data!$R:$R,CP!$B$16)),0)
My value here is 44 in cell C21. Is there a way to either click on the cell to show the raw data? What is my best option here?
