Hi Ladies and Gents,

I have learnt a lot from you as a silent reader.

Many issues were solved after reading your posts, but now I facing something that I couldn't find an answer to. Hope somebody know the answer.

I am trying to build a pivot table with calculated fields.

When I am using the columns that has been created from the raw data, it is easy, but when I am trying to use columns from that created by values the problem begins.

I explain via screen shoots:

Screenshot_73.jpg

Screenshot_1.jpg

Screenshot_2.jpg

"Brand Ratio" column has been created by a value calculation (on row data). When I try to create a calculated field out of it, it don't appear in the columns list.

How can I still do that?

Thnx in advance.

Keep the great work.