Hi,
I have a problem. I want to filter a dashboard using only one date filter. To get you into context, my table looks like this:
| Client_code | Product_name | Opening_Date | Cancelation_Date | Product_type |
| 327299 | CUENTAS CORRIENTES COMERCIALES DOP | 11/9/2016 | NULL | CC |
| 469276 | CUENTAS CORRIENTES COMERCIALES DOP | 7/17/2019 | NULL | CC |
| 49871 | CUENTAS CORRIENTES PERSONALES DOP | 9/18/2014 | NULL | CC |
| 80837 | CUENTAS CORRIENTES PERSONALES DOP | 5/14/2015 | NULL | CC |
| 391698 | CUENTAS DE AHORROS SIN LIBRETA DOP | 1/30/2018 | NULL | FF |
| 412379 | CUENTAS DE AHORROS SIN LIBRETA DOP | 6/26/2018 | NULL | FF |
| 413199 | CUENTAS DE AHORROS SIN LIBRETA DOP | 9/28/2018 | NULL | FF |
| 219594 | CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP | 9/26/2014 | 6/22/2016 | DF |
| 261286 | CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP | 7/23/2015 | NULL | DF |
| 383212 | CUENTAS DE AHORROS NÓMINA ELECTRÓNICA DOP | 11/23/2017 | NULL | DF |
The desired result would be the following (with a unique date filter):
| Product type | Opening | Cancelation | Net products |
| CC | XX | XX | XX |
| FF | XX | XX | XX |
| DF | XX | XX | XX |
Where I could count the amount of accounts opened and canceled in an specfic date range through a filter.
At the moment, I need to use 2 filters and use manually change them to the same date, and I cant get the net numbers. This makes my report bulky and unintelligible.
I was thinking about creating a table that actually tells you if the product is being Canceled or Opened at an specific date, making the date variable unique and creating a new variable named "Status". This means that all products would have at most 2 entries (Opened and Canceled).
In case you have a way to do this or another solution, dont hesitate to write.
Thanks in advance,
IC
