I'm trying to use Linear gauge Representation in my Pivot Chart. Unfortunately, I couldn't manage to scale properly the max value of the gauge for one of the type. Here is Expression for Max Linear Gauge - max(TOTAL <Type> Qty). The Data is just a straight table: EmpCode, Type, Qty.
As you see, Linear Gauge for lines scales is fine but for orders the max of the gauge seems the same as for lines. Why? Please, help me.