Dynamic column in table

[#1]

I wonder how to make a dynamic table depending on the number of selected data. Example: counting the total sales in the month. I would like to be shown in the columns of months, depending on the date range.

example 1

Scope of the date of January 1, 2014 to March 31, 2014

Product	January 2014	February 2014	March 2014
Car	12562,32	456543,45	85266,32

example 2

Scope of the date of 1 November 2013 to 31 March 2014

Product	November 2013	December 2013	January 2014	February 2014	March 2014
Car	124564,32	456463,14	146232,23	456,36	1456,36

[tresesco]

Try using pivot table.

Dimension1: Product

Dimension2: Months

Expression: Sum(Amount) // or something like that you would want

Then drag the second dimension column to the top.

[MK_QSL]

You can do the same using Conditional check of your selected month.

If you could provide some sample data would be helpful to give you answer...

[sushil353]

Hi,

Create a normal pivot table with the two dimensions. Then in the table, drag the date dimension header (you'll see a marker when you start dragging) to the top of the table, and the marker will change to horizontal. Drop it there and you will have a cross table.

HTH

Sushil

[its_anandrjs]

You can do this any straight table also with

Dimension:- Product,Month,Year

Expression:- Sum(Sales)

[its_anandrjs]

Take a Straight table or a pivot table

Dimension:-

Product

Month Year

Expression :-sum(Sales)

Take a snap shot for that