Slow Calculations

[tmumaw]

Good Morning everyone,

I am having an issue with the amount of time it's taking to do a calculation.  When I select a singles sales office response is fine, however when I select a company code the CPU pegs.....Here is my count statement.

Thanks

count(distinct(if(FISPD = FISPD_CNT and InActive = '1' and FISYR = FISYR_CNT,[Employee Number])))

[Anonymous]

Glad to hear you're making progress.  See attached.  I added a different pivot table that seems to be more accurate and simpler to me.

I can't help but feel like there are better ways to do what you're attempting by making data model changes.

To get rid of the null Action you would need to add Action as part of your link key.

I would probably do an inner join between your summary data and all distinct action so that I could then add it to the link key,  Then your null actions would be gone.  And also add a manual Action for the summary data of 'TOTAL' so I could use set analysis wherever I needed to get the summary total without duplication.