What is the problem or goal the end user is trying to solve or accomplish?
The customer needs to calculate values as a fraction of total rows in the new Interactive Pivot Table, specifically to measure logged time against clients. This functionality is critical for comparing proportions across categories, which was possible in the legacy pivot table.
How are they solving it currently?
Currently, the customer cannot replicate this calculation in the Interactive Pivot Table. As a workaround, they must use the legacy pivot table or attempt to manually calculate fractions outside of Preset, which adds friction and reduces the usability of the new pivot table feature.
What is the recommended solution by the Customer?
The customer requests the addition of the “Sum as Fraction of Rows” aggregation function in the new Interactive Pivot Table, restoring parity with the legacy pivot table and ensuring continuity for existing workflows.