Avatar

Level 1

Hi Steve,

thanks for the example ... nice and close but not 100 % solution.

The sample requires me to set up the summary table with fixed rows.

But I don't know how many main categories & subcategories will be there - it can vary between 2 and 20.

One solution would be to set up a table with 20+ rows and hide them if rawValue ... equals 0.

Might work -  but is not very elegant ....

I guess I was looking for the script that counts the instances and then creates automatically the necessary rows.

I know it is a lot to ask in a forum ... but I guess it might be possible. Isn't it??

Please let me know if I'm reaching for the impossible 

Jixin