Aggregate values in chart

Aggregate values in chart

Posted by: experdot.xie on 24 March 2021, 5:13 am EST

• 

  experdot.xie

  • Post Options:
  • Link
    Copy

  Posted 24 March 2021, 5:13 am EST - Updated 30 September 2022, 3:26 pm EST

  There is a data source which is with the following columns:

  • DateTime
  • SalesPerson
  • Amount
    
    I can aggregate the amount in PivotTable by “RUNNINGVALUE(“field”,SUM,“scope”)” function. And I want to know how to do it with chart like the picture below.
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2021, 1:58 am EST

  Hello,

  You can simply set the RunningValue Expression in the Value as shown in the attached image.

  Thanks,
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2021, 1:58 am EST - Updated 30 September 2022, 3:26 pm EST

  

  1079×647 32.1 KB

• 

  experdot.xie

  • Post Options:
  • Link
    Copy

  Posted 25 March 2021, 5:26 am EST - Updated 30 September 2022, 3:26 pm EST

  I tried a lot, but it doesn’t work in ActiveReports14 MVC Designer.
  
  Design:
  
  

  

  1524×695 50.1 KB

  
  
  Preview:
  
  

  

  1155×695 24.9 KB

• 

  experdot.xie

  • Post Options:
  • Link
    Copy

  Posted 25 March 2021, 5:38 am EST

  In pivot table the running value formula is following:
  
  =RunningValue(Fields!Amount.Value,SUM,“PivotTable1_Person1”)
  
  “PivotTable1_Person1” is a column group in pivot table.

  What the 3rd argument scope should be in chart?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2021, 11:40 am EST

  Hello,

  There is no need to add the scope. Please refer to the attached report. If issue still reproducible, Could you please modify attached one or provide your own report so that I can replicate the issue at my end.

  Thanks,
  
  Mohit
  
  Chart_Test.zip

• 

  experdot.xie

  • Post Options:
  • Link
    Copy

  Posted 25 March 2021, 10:30 pm EST

  I want to count everyone’s sales trends, so there should be “person” legend in the chart. The chart below is actually what I expected.
  
  data.zip

• 

  experdot.xie

  • Post Options:
  • Link
    Copy

  Posted 25 March 2021, 10:30 pm EST - Updated 30 September 2022, 3:26 pm EST

  

• 

  experdot.xie

  • Post Options:
  • Link
    Copy

  Posted 27 March 2021, 2:10 am EST

  OK. Thank you~

• 

  experdot.xie

  • Post Options:
  • Link
    Copy

  Posted 29 March 2021, 11:40 pm EST

  Could you do a simple rdlx file for me?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 8 April 2021, 7:26 am EST

  Hello,

  I have sent this issue to the development team (AR-26367)and will inform you once I get any update from them.

  Thanks,
  
  Mohit