Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a pivot table structured as below (several rows by customer).
I would like to set an expression in QV as in coluimn F. I would like to have the max value of Days repeated for each line by customer.
E.g. for customer 1, max value in column E (days), is 106, that's why in column F it's repeated for each row (same customer).
How i can achieve this?
Thank you so much!!
try
=max(total <CUSTOMER> DAYS)