Please find the attached Qvw. There are 3 sheets in the file. Each having Pivot table. The data showing in the table is not relevant. I need to order it. Details are mentioned in each sheet. kindly help me with this.
You can't handle everything on the fly. Even we assume you can, it will be terrible performance.
So you need to prepare or clean your data. Best way is to do it on the source. Not sure what your source is but if you can prepare levels on the source it is much better.
I mean, if they are on different levels, how can you show them on the same level? It does not make sense. If you are not preparing the data, you need to ask the relevant people to prepare it as is.
In the last sheet change all Level dimensions as horizontal and WBS_final_code as verticaly, so that it would be easier to understand since you have less number of columns, this format is more readable.
For remaining scenarios can you attach the expected output screenshots. I think this should be handled in script level.
Attach some sample data and your expected output screenshots.
I have some data coming from other sources. These data is due to some mistake during the data entry. Right now i dont want to correct it at the data level because it is done by someone else.
