
Re: In Pivot table, How to fabs firstly then sum
balraj ahlawat Nov 4, 2015 7:06 AM (in response to Jarven Wang)if Forecast and Demand are two expression in your chart, then use 3rd expression like:
Forecast  Demand //Expression label name, you can use abs() as well

Re: In Pivot table, How to fabs firstly then sum
Jarven Wang Nov 4, 2015 9:46 PM (in response to balraj ahlawat)in item level it worked
but if in higher level, the summary will sum first then abs


Re: In Pivot table, How to fabs firstly then sum
Sunny Talwar Nov 4, 2015 7:11 AM (in response to Jarven Wang)May be something like this;
Sum(Fabs(RangeSum(Forecast, Demand))) or
Sum(Aggr(Fabs(RangeSum(Forecast, Demand)), Item))
Sum(Fabs(RangeSum(Forecast, Demand))) or
Sum(Aggr(Fabs(RangeSum(Forecast, Demand)), Item))

Community_190292.qvw 149.0 K

Re: In Pivot table, How to fabs firstly then sum
Jarven Wang Nov 5, 2015 1:59 AM (in response to Sunny Talwar )Thanks for your guys anwser, the total amount will be aggrated on the top by the straight table
But in addition, if i want to display in month level ,for example
201505 2
201506 4
In pivot table it may expand to monthly item level, but here we knows must use straight table , so how to display the month level abs?
I need a chart to describe the monthly trend, so i need each month point abs first then sum chooco_co

Re: In Pivot table, How to fabs firstly then sum
jagan mohan rao appala Nov 5, 2015 9:06 PM (in response to Jarven Wang)Hi,
Just give month as dimension. The expression remains same.
This will work.
Regards,
Jagan.


Re: In Pivot table, How to fabs firstly then sum
Jarven Wang Jan 20, 2016 3:51 AM (in response to Sunny Talwar )Hi, thanks for your suggestions
And now there is a new questions after three month
Range Sum is the bottom level sum depends on the data
in my raw data, the bottom level is Month & Product
Quarter Month Product Forecast Demand 2015Q1 201501 P1 100 50 2015Q1 201503 P2 20 50 2015Q1 201503 P2 80 100 when I use your formula Sum(Fabs(RangeSum(Forecast, Demand)))
It could only get the monthly abs
How can I get the quarterly abs , and is it possible to have a formula or table to get each quarterly abs then dividied into monthly abs? (Use aggr or sum total)

Re: In Pivot table, How to fabs firstly then sum
Sunny Talwar Jan 20, 2016 5:01 AM (in response to Jarven Wang)May be this:
Sum(Aggr(Fabs(RangeSum(Forecast, Demand)), Product, Month))



Re: In Pivot table, How to fabs firstly then sum
Marco Hadiyanto Nov 4, 2015 10:30 PM (in response to Jarven Wang)Hi,
You can use this as your expression
sum(aggr(fabs(ForecastDemand),Item))
Hope this help
Regards,
Marco

Re: In Pivot table, How to fabs firstly then sum
jagan mohan rao appala Nov 4, 2015 10:56 PM (in response to Jarven Wang)Hi,
You can try using Aggr() like below
=Sum(Aggr(Fabs(ForecastDemand), item))
OR the best thing is calculate in the script itself
LOAD
*,
Forecast  Demand AS ForecastDiff
FROM DataSource;
Now you can straight away use
=Sum(ForecastDiff)
Note: If data is huge Aggr() will have performance issues.
Hope this helps you.
Regards,
Jagan.

Re: In Pivot table, How to fabs firstly then sum
Jarven Wang Nov 5, 2015 1:57 AM (in response to jagan mohan rao appala )Thanks for your guys anwser, the total amount will be aggrated on the top by the straight table
But in addition, if i want to display in month level ,for example
201505 2
201506 4
In pivot table it may expand to monthly item level, but here we knows must use straight table , so how to display the month level abs?
I need a chart to describe the monthly trend, so i need each month point abs first then sum

Re: In Pivot table, How to fabs firstly then sum
Marco Hadiyanto Nov 5, 2015 6:29 AM (in response to Jarven Wang)Hi Jarven,,
Can you share your simple data and your expected result so we can help you.
Thanks

Re: In Pivot table, How to fabs firstly then sum
jagan mohan rao appala Nov 5, 2015 6:35 AM (in response to Jarven Wang)Hi,
Just give month as dimension. The expression remains same.
Regards,
Jagan.



Re: In Pivot table, How to fabs firstly then sum
Prashant Sangle Nov 4, 2015 10:58 PM (in response to Jarven Wang)Hi,
did you try simple expression like
sum(fabs(ForecastDemand))
This will work.
Regards