Need to display values for all ID's .

[#1]

Hi Communtiy,

Please find the attached excel .

need to get values for all Branch Id's .

For April -420 , May - 480

these values should be displayed for all ID's .

Thanks and Regards

Satti  

[#2]

Try this:

=aggr(sum({1}SalesVolume),Month,Year,BranchID)

[#3]

Hi Nima,

No , it's not working . my reqirement is :

  for April -420 irrespective of Branch ID

  for May - 480 orrespective of Beanch ID

[jagan · Accepted solution]

Hi,

Pfa file for solution.

Regards,

Jagan.

[rwunderlich]

I think Jagan's solution is best -- you should use TOTAL instead of aggr(). However, the problem with your aggr(() was that you needed to add the NODISTINCT keyword.

-Rob

[#6]

Hi jagan ,

  Everything seems fine. but when i select particular ID , it's showing values for that id as well as it'showing  remaining ID's without values(-) .

when ever we select an ID , it should show the values for that ID only .

Can we make any changes furthur?

Thanks and Regards

Satti