Hello, I’m using the pivot table visual, but the ASP/seat (calculated field) is adding up the underlying results (as it would normally do in a pivot table) instead of dividing the ACV by seats. For Aug 2022, the ASP/Seat should be $0.86 ($135,487/157,643).
Is there an adjustment I can make that it doesn’t add the results, but rather calculates the two summed values?
Hi @cpalfi
Welcome to the community and thanks for posting your question.
If I understand correctly, could you try adapting your ASP/Seat calculated field to perform the aggregation (SUM) first, before the division takes place, e.g.
SUM({ACV USD Plan})/SUM({Seats})
If this works for you, please mark this as a solution.
Many Thanks,
Andrew
Hi @abacon
That worked brilliantly. Thank you very much!
My previous calculated field was {ACV USD}/{Seats}, adding the SUM() fixed the calculation when aggregating subtotals/totals in the pivot layout.
chris