Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a table with two columns year, month.
Now i want to create a table with columns year, month, sum of sales over year, sum of sales over month.
how to achieve it in qlikview?
Add two expressions:
=sum(Sales) // will calculate sum of sales over month
=sum(Total <Year> Sales) // will calculate sum of sales over year
Best,
Peter
can u elaborate that?
have to create a table with four columns