HOW TO CONCATENATE BOTH PIVOT TABLES TOGETHER

[#1]

Attached is my qvw. In management sheet there is 2 pivot tables which need to be grouped into one table

Anyone have an idea how this can be done??

[Anonymous]

Dear bilalelabd,

      create a inline table backend for those 13 exprsessions lables,that inline table is use full for merging a two pivot tables,other wise please provide a sample data ,i will provide a solution .

Regards

[#3]

I attached a simplied example.

the purpose of mergining is to have the following table

Expression           Dec            Jan             jan V.s   December             average(all months)

----------------          -----          ---------         ----------------------------          ----------------------------

Admission Q        98               90                       (  90-98)/98                  (98+90)/2

Please reply as soon as possible. This is very important for me

[#4]

Any more ideas ???

[Anonymous · Accepted solution]

Hi, 

    Please find the attachment  and let me know,

i written three expressinos only same way you want to implement another six measures.

Regards

[#6]

MAn this is a great idea. Many Thanks