Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ravindraa
Creator
Creator

Multiplication issue on sales and price

Hi Experts,

    I am struggling in one issue please help to come out from this issue.

we have two files like sales_File and price_file . we have to show case value(Sales * Price) information but it is taking aggregated value like below.

Multiplication.PNG

 
 

But my requirement is it shouldn't be multiple aggregated sales and price. it should be multiple month sales and same month price then next month also Ex: like below

EachMonthmultiplication.PNG

The above image showing aggregated result like sales -110 and price is -20 = 110*20 =2200

in below image showing correct values sales each month sales and price are multipleing the values.

we need below information, kindly give any suggesion.........

i have attached the dashboard.

please give me any suggestion how to solve...

 

1 Reply
ravindraa
Creator
Creator
Author

Hi Experts,

   Please give any suggestion.....