Could someone please advise me on how to do the below mentioned one in Qlik sense .
- I have a table with 10 columns in that two columns (column1 , column 2 ) are having 10 categories each and both columns are having same categories. And there is one more column called sales which contains sales numbers. Also, I have created a variable input drop down box which contains values like name, year, and location. How can I create a table in Qlik sense with first column as drop-down box values and then horizontally two headers with Column 1 and Column 2 and then under that 10 categories and for each category how can I do summation of sales.
