obtain a value in xl reporter

[Former Member]

HI,

how can i divide from a unique accounting period in several months for sales, That is I want to obtain as many columns as many months of the accounting period. thanks a lot

[former_member408229 · Accepted solution]

Hello,

In XL report designer, create a parameter for period.

Choose the column that you want to expand, click on the Selection icon from the left side box(next to the Expand icon).

Then you will get as many columns as the months chosen.

Hope this helps.

Regards,

Maggie An

SAP Business One Forums Team