Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
can any one have idea that how to find Maximum value in individual row in pivot table excluding total value at the end?
Same for Maximum value from entire pivot table excluding total value row and column which is last row and last column.
Thanks
Dipak
calculate max value for each dimenison in script & compare with that value in the chart
Hi,
Can u post ur pivot table here ?
Regards
You are looking something like this??
see atach
Basically i want to change the background color of the maximum value in row and maximum value in pivot table.
How many dimenisons u have in ur pivot table ?
Could you post the excel export ?
Regards
Thanks for reply.
Please find attached xls file.
Here you can see that i want to hightlight all the cells which have maximum value in row.
Thanks
Dipak
Hi,
I am having the same problem
did you find the answer
?
Thanks,
Ester
Hi,
I am having the same problem
did you find the answer
?
Thanks,
Ester
calculate max value for each dimenison in script & compare with that value in the chart
I thought there was a simpler way,
Thanks for the reply,
Ester