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

[#2]

Dear Sudeep

Thanks for the example.

But when I select a year in your example, it shows me the 2013 no more.

Kind regards

[sudeepkm]

it is dynamic. If you select year as 2013 or if you select any dates that is under 2013 then the table will show all the 2013 date related data same works for when you select year as 2014.

Do you want to show the table all data irrespective of any date selection?

[#4]

The point is, mostly the selected year is 2014 (like in the left side of your picture)

And thats the point. It should show me nevertheless the 2013, also when the selected year is 2014.

But many many thanks for your help!

[its_anandrjs]

Try like below

For Month year dimension write like calculated dimension

Dimension1:- Client

Dimension2:- =if(GetFieldSelections(Years)=Years, MonYR, if(Year(Today())=Years,Year(Today()),MonYR))

Expression:- sum(SalesAmount)

[sudeepkm]

You can use an expression like sum({<Years=, MonYR= >}SalesAmount) in that table after which even if you select any year or month year the table remain shows for 2014 and 2013.