Is it possible to create dynamic Percentage of Spend Category Filter based on selected attribute?

Question

Hello,

I am planning to create a filter of percentage of spend bucket such as:

Top 20%, Top 21-50%, Top 51-80%, Top 81-100%

For example, I have selected Division as parameter, then the filter for the Percentage of Spend Category will adjust based on Division.

I am aiming to have something like this:

So the spend and the # of parts result per % bucket will adjust based on the 'Parts Analysis View' selected

Edwin_Martinez · Answer

Hi @JobDeLuna,

I hope this helps, but I find it the best way possible is to create custom filter calculations for each one of the buckets.

This is example of one that I did for 61-90 day Quick Quits.

CAST(FILTER("HCM - Workforce Core"."Facts - Workforce Events"."Hire Count" USING (TIMESTAMPDIFF(SQL_TSI_DAY, "HCM - Workforce Core"."Employment Information"."Work Relationship Start Date","HCM - Workforce Core"."Employment Information"."Termination Date")BETWEEN 61 AND 90))AS FLOAT)/"HCM - Workforce Core"."Facts - Workforce Events"."Hire Count"

JobDeLuna · Answer

Hi, @Mallikarjuna Kuppauru-Oracle  my problem is how to set up the percentage bucket

Mallikarjuna Kuppauru-Oracle · Answer

Hi @JobDeLuna

This is sort of pivot table with setup of KPI metrics , i hope you can able to do the same using  dv workbooks or any classic report.

Regards,

Arjun