Same header for more than one column

[#1]

I have the following table

Customer

Customer name

monthly tons

monthly sales

cumulative tons

cumulative sales

I want créate the following table:

                                                          Monthly                Cumulative

Customer     Customer name        Tons      Sales       Tons       Sales

As i define headers Monthly and Cumulative?

[eduardo_sommer]

You can use a calculated dimension for Monthly and Cumulative and expressions for Tons and Sales, like I did in the pivot table below:

Eduardo

[#3]

Thank you very much

But i must do so that in qlikview, so the header is displayed?

[eduardo_sommer]

Hi Preciliano

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.

Eduardo

[#5]

This is a example

[eduardo_sommer · Accepted solution]

I modified your example toshow you my idea.

I included an inline load for the Monthly/Cumulative dimension and created a new Pivot table object.

Eduardo

[#7]

Eduardo.

What happens if i add other columns

                                                                          Monthly          Cumulative

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

Thanks

[eduardo_sommer]

Unfortunately, the new expression will be repeated for each dimension (Monthly, Cumulative in your case), as you got in your qvw.

Eduardo