I have the following table
I want créate the following table:
Customer Customer name Tons Sales Tons Sales
As i define headers Monthly and Cumulative?
The table above was created using QlikView. Definining the Pivot Table, I used Customers as the first Dimension and a Valuelist('Monthly','Cumulative') as the second dimension (calculated). When the chart was displayed, I moved the second dimension to the right to be displayed as columns.
In the presentation tab, I defined the alignment of the data and labels.
In the expressions you need to make reference to the dimension to make the proper calculations (for monthly or Cumulative).
If this explanation didn't make it clear to you, I can recreate the app and upload it.
Let me know if this answered your question.
What happens if i add other columns
Year Customer Name Any expression Tons Sales Tons Sales Factor X
2013 30 3000 34 34000
1055 xxxxxx 0.1 10 1000 12 12000 5
2012 yyyyyy 0.2 20 2000 22 22000 7