Extra/Hide dimension

[Anonymous]

Hi Community

In my below report I need 2010 column which is not a part of dimension Stage1 & Stage2. How can I as Below please?

          |       Stage1    |     Stage2    |

  2010 |   2011 | 2012 |  2011 | 2012 |

      2  |     4     |   11  |     8   |   18   |

      3  |     6     |   13  |     2   |   12  |

      7  |     5     |   19  |     7   |   17   | as below

Sorting above as 1,2,3 with removing all Xs

QV attached

Thanks

[Siva_Sankar]

Satish,

You dont have common key for S9 in table S1. Find the attached qlikview file.

[Anonymous]

Hi Siva

I appreciate your answer, even after creating S9 common key, report does not fulfil the requirement Like

         |       Stage1    |     Stage2    | 

  2010 |   2011 | 2012 |  2011 | 2012 |

      2  |     4     |   11  |     8   |   18   |

      3  |     6     |   13  |     2   |   12  |

      7  |     5     |   19  |     7   |   17   |

As I want in your report(exactly as above)

1. Hide header Stage9

2. I need 2010 column as first.

3. Hide 2010 under Stage1 & Stage2

Thanks for your quick answer