Hi All,
i was trying to plot a graph with a keyfigure that is Cost/MT. however, the cost/MT is getting added up and not showing individual value. for example
year 1, month 1, product 1, qty 10, cost 200, cost /mt = 20
year 1, month 1, product 2, qty 10, cost 300, cost /mt = 30
year 1, month 2, product 1, qty 5, cost 200, cost /mt = 40 ( price changed )
year 1, month 2, product 2, qty 4, cost 300, cost /mt = 70 ( price changed )
if i take cost /mt for each month it should be
month 1, total qty 20 total cost 500 so cost /mt = 25/MT
but instead what i get is its summed up, that is 20+30 = 50/ MT
when i see in "Edit Query Specification" mode its coming correctly as 25/MT, but in "Edit Initial View" mode of query, it summing up that is 50/MT
any way we can fix this issue.
your support wil be greatly appreciated.
thank you.