I have a bar chart showing expression( like Sales) by monthname(Date)..Now ehn I am selecting Jan 2017 bar, it is showing some other sales value, if Clear the selection, Jan 2017 shows different value

[#1]

Hi All,

I have a bar chart showing expression( like Sales) by monthname(Date)..Now ehn I am selecting Jan 2017 bar, it is showing some other sales value, if Clear the selection, Jan 2017 shows different value

Any Suggestion why this aggregation is changing on selection.

Regards

Sid

[sunny_talwar]

What is the expression you are using?

[#3]

=sum(aggr(sum(Distinct(<Flag={0}>} Freq*Amount),AccountNum)

+

sum(aggr(sum(Distinct(<Flag={2}>} Freq*Amount),,AccountNum)

[#4]

Hi Sunny,

I need to calculate Freq*Amount where Flag={0} or where Flag={2}, also there is one more condition, I need to calculate on distinct Account Num.

For Simplicity. I have used Flag =0 but it has 3 different conditions in real example

Regards

Sid

[sunny_talwar]

Are you able to share a sample to better see your data model and also what you are trying to do?

[#6]

Hi Sunny,

I am thankful to you again,When you asked me about the expression for the chart, I re wrote it, This time in more simple way and Yes, Now my issue is resolved

Regards

Sid

[sunny_talwar]

Awesome

I am glad you managed to resolve it