Skip to main content
Question

We created an OLAP table which KPIs are calculated through pu_function (it is the only way to ensure analysis correctness). If we filter the sheet with a "date picker" , KPIs have values not coherent between themselves.

  • July 26, 2021
  • 1 reply
  • 4 views

Forum|alt.badge.img+7

It seems that date picker filter is not applicated in the same way for:

  • the KPI in the high side of the sheet (Sales Order Items value and Number)
  • the KPI in the table that shows year by year Sales Order Items value and Number
  • the values (Sales Order Items value and Number) for a specific customer if we add also this filter

Because for some customers each of them shows different values ..

1 reply

joos.buijs
Level 10
Forum|alt.badge.img+2
  • Level 10
  • July 27, 2021

Please read the PU function documentation carefully as they react unexpectedly on filtering.

 

My assumption / gut feeling, is that they obey filters for the 'group by' table you provide (the first argument), but not for the second argument / child table. But I could be wrong!!!