Nagaraj475
New member
I work for a contact center and the cases handled by employees will be surveyed. Customers would rate the interacton as Satisfied or Dissatisfied. By applying a pivot table for the data dump, we can get the day's and the month's CSAT score.
I'm looking for a way to get the cumulative values in pivot table automatically. Like the subtotals. The table has to show CSAT percentage from Day 1 to 2,3,4..... This will help me identify the CSAT trend like in a Stock price chart. Please check the attached example file. The file has two sheets one with data and the other has the Pivot table with Average formula in field settings. I'm sorry if the explanation is not clear. I will try to elaborate it further if needed.
Thanks in Advance.
Nagaraj
I'm looking for a way to get the cumulative values in pivot table automatically. Like the subtotals. The table has to show CSAT percentage from Day 1 to 2,3,4..... This will help me identify the CSAT trend like in a Stock price chart. Please check the attached example file. The file has two sheets one with data and the other has the Pivot table with Average formula in field settings. I'm sorry if the explanation is not clear. I will try to elaborate it further if needed.
Thanks in Advance.
Nagaraj