How to show every single month of the last year?

[#1]

Hi All

I've got a List for our sales, it shows the actually year (like 2014) in one colum.

And in the other colums it should show every single month of the last year.

Let's show this a little bit better:

Client     /     sales 2014     /     Jan 13     /     Feb 13     /     Mar 13 etc.

I'm really thankful for any help.

Nice day to all!

Dominik

[its_anandrjs]

Use pivot table for this like

Dimension:- Client

Dimension :- MonthYear

Expression Sales2014

and drag the Monthyear field to the upper right corer and when you see horizontal blue arrow drag the field therer.

[alexandros17]

Use Year and month as dimension and sum(sales) as expression (your expression).

Create a pivot table, then drag the month field to the head of the table (until you see an horizonatal line)

Let me know

[#4]

you can create 'Sales 2014' as Dimension (Calculated dimension) and rest as usual pivot table dimension values..

Regards,

Karthik

[its_anandrjs]

And expression level you can do like

Dimension:- Client

Expression Sales2014

Expression :- Sum( {<NumMonth = {'$(=Month(Today())-3)'} >} Sales)

Expression:-  Sum( {<NumMonth = {'$(=Month(Today())-2)'} >} Sales)

Expression:-  Sum( {<NumMonth = {'$(=Month(Today())-1)'} >} Sales)

Expression:-  Sum( {<NumMonth = {'$(=Month(Today()))'} >} Sales)

[#6]

Hi Alessandro   

The problem is, i've got a selected year (2014).

And because of the selected year it only shows the months of this year. But i want every single month of the last year to show.

See the picture below

Kind regards

[alexandros17]

Let's suppose that your expression is Sum(Sales) and that your dimensions are year and month then write:

Sum({$ <month=>}Sales)

Let me know please

[alexandros17]

Sorry

Sum({$ <year=>}Sales)

[nizamsha]

Year and month as dimension and ur expression sum({$<year=,month=>}sales)

[sudeepkm]

pls take a look at the example.