Using above function in Bar/Line Chart

Pulkit_Thukral — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

PFB Screenshot on which my complete development is based:-

In the above table,i am using 2 dimensions-Month and StorageType(HUS or VSP), others are expressions.

Expression 1 uses a above function with complete expression:-

if(month ='Jul',if(storage_type='VSP','1083','178'),

above([Capacity Baseline-Storage])+above(BAU)+above(SCR)+ above(Reclaim))

This gives perfect result as shown in the above table.

BUT, when the same table is converted to a Bar/Line chart, it gives me only the first (default 'hard coded' value for the month of july).

PFB Screenshot:-

How can i get same figures in this chart as were coming in pivot table.

What extra do we have to use in the expression.

Re: Using above function in Bar/Line Chart

Pulkit_Thukral — Thu, 12 Jan 2017 07:41:49 GMT

Have i made the requirement clear guys?

i request urgent help in this matter.