Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Could you please help me with the requirement
i have got the below table
Month | Value |
Jan | A |
Jan | B |
Jan | C |
Jan | D |
Feb | A |
Feb | B |
Feb | C |
Mar | A |
Mar | B |
Mar | C |
Mar | D |
Mar | E |
Expected Result :
if the User Selects, JAN - The distinct count of values in Jan- 4
if the User Selects, JAN +FEB - The distinct count of values in JAN+FEB - 4
if the User Selects, JAN +FEB+MARCH - The distinct count of values in JAN+FEB+MARCH - 5(A,B,C,D,E)
expected result | |
jan | 4 |
Feb | 4 |
Mar | 5 |
Thanks in Advance
No, it doesnt work