Multiple columns for similar dates field

[Former Member]

Hi There,

In BEx reporting my client wants the report for different dates as ...

Used the formula and replacement path for making the dimension to key figure (dates).
But the problem arises after is the following

similarly, for every different date... query is opening the new columns.

Suggestions needed for the query.

Thank you in advance.

[kohesco]

Hi,

can you share a picture of your setup in BEX query designer

please