Thanks. I was able to create calculated fields based on your second link. Now I need to create a pivot table. How do i create a pivot table based on the table I just created with the calculated columns?
There is an object type -> Pivot table. You need to use that to create a pivot table. A regular table cannot be converted to Pivot table (at least that's what I know based on my limited knowledge of Qlik Sense)
Update: You should be able to copy paste your calculated dimension to the pivot table