Count of records

Hi Team,

i request your help below query.

I have three grid in my dashboard. second grid showing associate details(selected associate in first grid) with account name details he belongs in PA level.

Third grid showing account name details of same person in BU level.

1) I need to display one more column showing total counts of accounts in both grid (second & third ) along with the account name.

2) On first grid (quota summary grid) the total number of accounts (3rd column) = number of accounts in second + Number of accounts third grid .

How can i achieve it. adding all grid pic below for reference.

Grid -1

Grid -2 (showing each associate accounts name in PA level)

Grid -3 showing associate account name in BU level

Please help me to achieve the same.

Accepted answers

All comments

Anilkumarch

Hi @Jerin_KJ i did not understand the relation between the PA and BU (I mean summing accounts in 2nd & 3rd for total accounts in 3rd grid). But you can achive this my adding a Count line item which values is always equal to 1 and then you sum be person so that you get total accounts of that person in 2nd grid.

Also you can also use RANK function to get count of accounts and take the MAX rank which will give you the total accounts.

Give the relation between grids in details if you are not able to get it.

Jerin_KJ

HI Anil,

Thank you for the reply with guidance. Now i am getting level mismatch error ( all these three grid have different dimensions). hw to proceed?

Thanks

Jerin

Anilkumarch

Hi @Jerin_KJ ,

If you can provide the details of relation between the dimensions used in grids then i can help. Without knowing the relation between the dimensions it is difficult.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…