Skip to main content
Solved

Hi all, i have an olap table with the dimension of all my activities and as my kpi the count of the activities (done with count table of all activities).

Level 6

Now i want to have this number for Change Price as a single KPI number, my idea was to use the count table for the kpi and a Component filter with 'FILTER PROCESS EQUALS 'Change Price''. But it shows me a much larger number. Can pls anyone help me. Thanks in advance, king regards Louisin the olap table

Best answer by rita.kiss12

I think that for the component filter, you need to filter directly on the activity name.

KPI: COUNT_TABLE("_CEL_MERGED_ACTIVITIES")

Component filter:

FILTER "_CEL_MERGED_ACTIVITIES"."ACTIVITY" = 'Change Price';

View original

    2 replies

    rita.kiss12
    Level 7
    Forum|alt.badge.img+3

    I think that for the component filter, you need to filter directly on the activity name.

    KPI: COUNT_TABLE("_CEL_MERGED_ACTIVITIES")

    Component filter:

    FILTER "_CEL_MERGED_ACTIVITIES"."ACTIVITY" = 'Change Price';

    Level 6

    Thanks a lot, now it works

    Community Code of ConductAccessibility statement