This content has been marked as final. Show 2 replies
I'm just starting out with QlikView, but I'm struggling a little to get into the syntax side of things (I'm happy enough pulling the data from Excel and SQL DBs). I have a small set of sales data and I want to calculate a weekly contribution percentage. So, for example in the table below I have the first three columns, but I can't work out how to calculate the fourth:
I've used sum(sales)/sum(total sales) to get an overall contribution, but this isn't particularly useful. What am I missing?