Hello everybody, I want to know how can i get the detail
of a amount data from excel.
For example
Year
Client 1 2 3
a 10 20 30
b 35 45 15
c 10 11 12
d 20 22 24

Client b in the year 2 and the amount data is 45 from
value1+value2+value3+value4+value5+...=45 could be any
value but the amount is 45, MY QUESTION IS HOW CAN I GET
IT FROM PIVOT TABLE and show it IN EXCEL?

Best regards