Forum Discussion
Table with Dynamic Column
Hi, Anonymous
Is this the result you expect? There is no direct relationship to the date column.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-zhangti
Refer to this sample, please.
User input: 30/04/2022
"Data Considerada" = "User input" + 3
"O-Q" = "Data Considerada" - "Data-base fim"
Input:
| Order ID | Category | Data-base fim | Data Considerada | O-Q | B Plan | Critico | B Critico |
| 1 | 001 | 04/10/2021 | 03/05/2022 | 211 | 1 | 0 | 1 |
| 2 | 001 | 24/01/2022 | 03/05/2022 | 99 | 1 | 0 | 0 |
| 3 | 001 | 24/01/2022 | 03/05/2022 | 99 | 1 | 0 | 0 |
| 4 | 001 | 14/03/2022 | 03/05/2022 | 50 | 1 | 0 | 1 |
| 5 | 001 | 07/03/2022 | 03/05/2022 | 57 | 1 | 0 | 0 |
| 6 | 001 | 23/11/2021 | 03/05/2022 | 161 | 1 | 0 | 0 |
| 7 | 001 | 20/11/2021 | 03/05/2022 | 164 | 1 | 1 | 0 |
| 8 | 002 | 08/11/2021 | 03/05/2022 | 176 | 1 | 0 | 0 |
| 9 | 002 | 06/12/2021 | 03/05/2022 | 148 | 1 | 0 | 0 |
| 10 | 002 | 06/12/2021 | 03/05/2022 | 148 | 1 | 0 | 0 |
| 11 | 002 | 13/12/2021 | 03/05/2022 | 141 | 1 | 1 | 0 |
| 12 | 002 | 15/11/2021 | 03/05/2022 | 169 | 1 | 1 | 0 |
| Total | 12 | 3 | 2 |
Output
| Category | Sum of B Plan | Sum of Critico | Sum of B Critico |
| 001 | 7 | 1 | 2 |
| 002 | 5 | 2 | 0 |
| Total | 12 | 3 | 2 |
It doesn't need necessarily to show total on the table.
What I do need is a total to show in a card visual. But if a insert "B Plan" in a card, for example, it doens't show the total = 12.
I also need these results to sum to another measures from another table.
Hi, Anonymous
Is this the result you expect? There is no direct relationship to the date column.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.