Straight table sum of Rows value of Expression in a text object

[agastya]

Year filter :-2017|2018|2019|2020

In straight table 

If I am selecting 2020 filter it should calculate  2017data from to 2020 till date (it's working) properly

Below expression:---

Count({created_year=, created_month=, Submitted_date={"<=$(=max(Submitted_date))"}>}pwg)

Count is:-35110

Text object:-

I have copied the same expression pasted to text object chart 

Sum(Aggr(Count({created_year=, created_month=, Submitted_date={"<=$(=max(Submitted_date))"}>}pwg), primary_number)) 

If I am selecting 2020 filter it should calculate data from 2017 to 2020

It's not evaluating properly 

Expected output:-in text object after selecting 2020 filter only 

35110

Please help me out

Thank you 

@sunny_talwar @sunny_talwar @sunny_talwar 

[agastya]

Anyone??

[bharathadde]

I'm assuming you are calculating aggr by Primary Number in text box. 

Can you clearly explain what dimensions are you using on straight table and what output do you need on text box.

if you can share sample data that would be great.

[agastya]

Dimension primary number

Straighttable sum of rows should be output in text box

[bharathadde · Accepted solution]

Try this

Sum({1}Aggr(Count({created_year=, created_month=, Submitted_date={"<=$(=max(Submitted_date))"}>}pwg), primary_number)) 

or

Sum(Total Aggr(Count({created_year=, created_month=, Submitted_date={"<=$(=max(Submitted_date))"}>}pwg), primary_number)) 

[agastya]

Thank you bharath its working