Skip to main content

Hello,

 

I have five billing periods on my data source. Please see the original dataset:

Merge two dimensions/filters into one?I excluded first two for reporting on my dashboard (“BAK2017” and “BAK2018”), so I created a set of three (“Billing Period Set”) which I am now using as a filter:

2021-05-17_21-36-46 

However, the last billing period “UUBAK2020” should be merged and reported together with “BAK2020” (under the unified label “BAK2020”, so it captures total packages sent from both reporting periods-21).

 

Below is the result I am hoping to get, only two values presented in the filter BAK2020 and BAK2021 (also includes values from “UUBAK2021”).2021-05-17_21-41-46Can you please tell me how to merge two filters/dimensions into one (to get the result above)?

 

Thank you for your help

1 answer
  1. May 17, 2021, 8:41 PM

    Hi there,

    you just need another calculation to replace some of the values.

    IF [Billing Period]="UUBAK2021" THEN "BAK2021"

    ELSE [Billing Period] END

    Here is the calculation in the view:

    Hi there,you just need another calculation to replace some of the values.IF [Billing Period]=Document attached.

    thanks,

    Adrian

0/9000