Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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...
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
You can do this any straight table also with
Dimension:- Product,Month,Year
Expression:- Sum(Sales)
Take a Straight table or a pivot table
Dimension:-
Product
Month Year
Expression :-sum(Sales)
Take a snap shot for that