Expression wise Average

[nuwanhwb87]

Hi All,

Need a Help.

My above table is a pivot Table.

Dimension in Month. Expressions are Efficiency, Running Machine, Quality Rate.

Unable to get the last column in the above attached image (Avg/Total ) by Expression wise 

Please help...

[MayilVahanan]

HI @nuwanhwb87 

Try like below

Dim:
load * inline [
Dim
1
2
];

Dim:

=If(Dim=1, Month, 'Avg/Total')

Expression:

If(Dim=1, urexp, avg/total expression)

[nuwanhwb87]

Sorry . Didn't get this.

In the chart

Dimension is month - (But it has change in the Display as a Field/ But originally it is dimension )

Expression - Efficiency

                          Running Machine

                          Quality Rate