I think the best approach here is to create a cross-tab table for Time frame A and another 3 different table for time frame B and variance $ and variance %. now im assuming that its a fixed column table so you wouldnt be needing relative position. just connect them side by side.
I can’t put the three different tables side by side, bcoz when the user changes the prompt input, lets say 5 profit centers, the tables will get overlap.
Is their any other solution where i can combine all the three tables dynamically based on the user prompt input.
Could you position the tables underneath each other? A suggestion is to place each value selected from the user prompt in separate variables, and use these variables to filter out unwanted values in the specific block. In the first block, you can compare the first 2 values selected from the user prompt (and use the first 2 values in the block filter). I’m assuming then you’d compare the 3rd and 4th user response values, and then you can filter the block on those values inputted? Your sample only shows how the report looks for 2 cost centers.
I have around 15 profit centers, and the user may choose any multiple combination values. Those values appear in the place of Value cut in the excel file which the user has chosen has multiple values.
What i was trying to do is, i created a cross tab, At the Top i Place Time frame A and Time frame B and then i created added a row below and tried to place the profit centers for both Time Frame A and Time Frame B.
Now the problem is, when i add the profit centers, its not able to show the chosen profit centers for Time Frame A as a group, instead it is showing Time Frame A, below 1 Profit center and then next column is Time Frame B and 1 profit center, where as my requirement is , i want All the Profit centers under one combination for Time Frame A and then Group of combination for Time Frame B.
(BOB member since 2009-08-03)
(BOB member since 2008-12-02)