Hi,
Below my input columns and i mentioned required output as well. please help me in finding the output in Stright table.
Input table:
L1 L2 User_ID Month year
A AA A1 Jan 2022
A AB A2 Jan 2022
A AC A3
A AA A11
A AB A21 Jan 2022
A AC A31 Jan 2022
A AA A4 Jan 2022
A AB A5
A AC A6 Feb 2022
B BA B1 Jan 2022
B BB B2
B BC B3 Jan 2022
My output should be in stright table, If i apply filter L1 = A, Month = Jan and Year =2022 it should display as below. L1, L2 are my dimensions and Expression are Total_Dist_Count must be total distinct count of User_ID irrespective of selection
and Dist_Count_month should not show count of Distinct User_ID according to month and year filter. If i apply filter L1=A, Month=Jan and Year=2022 the output table should show as below and it should not show L1=B values in it.
Output table:
L1 L2 Total_Dist_Count Dist_count_month
9 5
A AA 3 2
A AB 3 2
A AC 3 1
