Pivot Table Aggregation

[manish_kumar]

I have a data along two dimensions having date (Date1, Date2) (attached data).

I need the data in the first column whenever the data flow in Date2.

Please refer the attachement.

[petter]

It is possible to get a solution like you hope for:

Had to let the associative model help me to shift the columns to the left by using this helper table... I know ... it could have been done programmatically but I just hacked this together - so feel free to code a more elegant solution.

[manish_kumar]

HI Petter

Thanks for the solution.

But I am stuck in making the columns dynamic. Is there any way out to make the combinations Dynamic because rows and columns will increase on regular basis and it will be very difficult to define the combinations every time in inline table.

[petter]

You mean the QY table?

[manish_kumar]

Yes QY table..

[petter]