Hey Qlik Developers!
I have a table with this information:
| Date | Name | Type | Amount |
| 19/10/2020 | name1 | Type1 | 80 |
| 19/10/2020 | name6 | Type1 | 10 |
| 19/10/2020 | name2 | Type2 | 10 |
| 20/10/2020 | name3 | Type1 | 50 |
| 20/10/2020 | name4 | Type3 | 50 |
| 21/10/2020 | name5 | Type1 | 60 |
With this data I want to show a table chart with the percentage of amount for each type in a given date, like this:
| Date | Type | Sum Amount | Percentage of day |
| 19/10/2020 | Type1 | 90 | 90% |
| 19/10/2020 | Type2 | 10 | 10% |
| 20/10/2020 | Type1 | 50 | 50% |
| 20/10/2020 | Type3 | 50 | 50% |
| 21/10/2020 | Type1 | 60 | 100% |
How can I achieve this? I'm having trouble calculating the percentage and sum taking into account the date.
Kind Regards,
Felipe.
