Linear Gauge

[MK_QSL]

I have Customer, Month, Brand and Sales Data.

For Pivot Table from enclosed file, I want to show three different colour for each Brand.

i.e. For Customer X, Jan Sales should be 301 but there should be three colours based on B1 100, B2 120 and B3 90.

[Anonymous]

Hi Manish,

Please find the attached QVW file in  he attachments.

I think your requirment is like that only//

[MK_QSL]

I don't want hard coded color.. .Colour should be based on respective sales on Brands

[tresesco]

Lower bound expression doesn't recognize dimensions.