Grouping crosstab dates by month

[Former Member]

Hi,

I'm new to SAP BI, and am trying to set up a crosstab query which gives me the count of customers by referral reason by date. The data has individual days, however I want to show the result by month rather than by day. How do I do this?

On the topic of being new to SAP BI, are there any good beginner/intermediate resources online which I can have a look at to get me started on this?

Thanks in advance.

[mhmohammed · Accepted solution]

Hi Clarence,

Create a variable for Month Year using the Date object available as below and then use it in the Crosstab:

=FormatDate([Date object];"yyyy MM")

Check this out:

SAP Web Intelligence E Learning:

Webi 4.1 SP5 User Guide:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp6_webi_getting_started_en.pdf

Thanks,
Mahboob Mohammed

[Former Member · Accepted solution]

Thanks Mahboob, FormatDate worked well.

Will check out the official tutorials as well.

[amitrathi239]

Format the date in webi to get the Month from date. After that use in the crosstab or table.

Let say you have data like

Date      Count of Customers

1/1/2014     4

2/1/2014     6

like this.

Create Variable V Date=Formatdate([Date];"Mmm")

After that if you drag V Date & Count of Customers in the table you will get data like this.

V Date Count of Customers

Jan               10