Top 10 :: Total % Value Issue

[krish2459]

Hi,

I'm using line chart to plot trend for Material stock correction at plant and Monthyear level.

But I'm getting Total percentage as negative which is wrong.

I'm limiting only top 10 materials.It seems like logic is taking entire value.

I need to limit logic to pick only top 10 materials at expression level.

Expression: 

(1-(fabs(sum(Amount))

/sum([Stock Value Main])))*100

Thanks,

Krish

[krish2459]

Any Suggestions.

Thanks,

Krish

[MayilVahanan]

HI @krish2459 

Change the totals function from Auto to Sum in expression

[krish2459]

Hi @MayilVahanan 

I'm using line chart.

We need to restrict in expression.

Thanks,

Krish

[MayilVahanan]

HI @krish2459 

Can you provide the sample file to verify