Count the total number based on filter KPI

jgerochi · 2025-02-22T03:43:51+00:00

There was an error rendering this rich post.

Hi,

I have a Count line item of employees that has a formula of 1 in my employees module. I have a Total Count line item on another module to show the Total Count based on Filter that has a formula of:

my Filter formula is:

How do I show the total count of employee based on the filter?

Thanks

Accepted answers

lokeshm

@s.hasrio

Please change the highlighted one to users and and bring then region flat,country flat etc to bottom .In this way Total employee count line item will not be subsidiary view and the data will be shown in the page.

All comments

lokeshm

@s.hasrio create another line item (dimension is based on your requirement ,if you want to show only count of all employees keep this line item dimension to none)to bring the sum of all employees

formula: count line item [select:employee:ALL]. Here count line item is the one you have created with the formula.

jgerochi

Hello, @Lokesh_Madhu

I'm kinda confused. Can you elaborate?

Below are the modules and line items I am referring to.

Thanks.

lokeshm

@s.hasrio I am assuming you have used user dimension in the both modules. In the Employee flat list , you need to have top level item.

after this write the formulas as

Hope this helps you.

jgerochi

Hi @Lokesh_Madhu,

It doesn't work on my end

Dikshant

jgerochi

@Dikshant Hi,

I tried yet it doesn't show anything on my card

Dikshant

Can you open the subsidiary view for Total Emp Count line item and check if there is any value there?

Dikshant

Also can you share what's the logic for SYS12 Filter?

lokeshm

@s.hasrio

jgerochi

@Lokesh_Madhu it works! thank you so much for your help! the employee salary value doesn't appear on my card after the changes, so I just created a separate module for the count and salary.

thank you too @Dikshant! I appreciate the visual.

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled