Aggregate values in chart

Posted by: experdot.xie on 23 March 2021, 8:13 pm EST

  • Posted 23 March 2021, 8:13 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.
  • Replied 24 March 2021, 4:58 pm EST

    Hello,

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

    Thanks,
    Mohit
  • Replied 24 March 2021, 4:58 pm EST

  • Replied 24 March 2021, 8:26 pm EST

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

    Preview:
  • Replied 29 March 2021, 2:40 pm EST

    Could you do a simple rdlx file for me?
  • Replied 24 March 2021, 8:38 pm 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?
  • Replied 25 March 2021, 2: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
  • Replied 25 March 2021, 1: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
  • Replied 25 March 2021, 1:30 pm EST

  • Replied 7 April 2021, 10:26 pm 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
  • Replied 26 March 2021, 5:10 pm EST

    OK. Thank you~
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels