Nandha,
Well, as far as I can understan, you have a or various tables with your data (not the inline table Month) with your values and also one or various dates fieds. Those fields must be used to create a calendar or diferent fields with your dates type (month, year, Q, etc.)
For example: You have a table with your sales per days like this
| Date | Article
| Cantity | Unit Price | Total |
|---|
| 01-10-2012 | Pen | 5 | 25 | 125 |
| 05-10-2012 | Paper | 2 | 10 | 20 |
| 15-11-2012 | Light | 10 | 5 | 50 |
| 18-11-2012 | Pen | 8 | 25 | 200 |
| 01-12-2012 | Paper | 6 | 10 | 60 |
Now, in your script when you load your data, you can create new fields based on your original data table, in this case the Date fields.
For example (read all the date format in Help menu)
month(Date) as Month,
Year(Date) as Year,
'Q' & ceil(Date / 3) AS C_Quarter,
'Q' & ceil(Date/ 3) & '-'& Y AS C_QuarterYear,
week(Date) AS C_Week,
weekday(Date + 2) AS C_Weekday,
weekName(Date AS C_Semanas,
day(Date AS C_Day,
date(Date,'DD/MM/YY') AS C_DateDDMMYY,
QuarterName("Date") as C_Trimestres,
Monthname("Date") as C_Mes,
Month(today()) as C_MesActual,
inmonthtodate("Date", $(vToday), 0) * -1 AS C_MTD,
So, doing that you can have a List Box and select the month, week, Q, etc as you wich and your Pivot table will display the data for such month, week etc... If you wich to change the display title of the dimensions, only put the field in the subject and it will change also.
On the other way, you will maybe need a master calendar, but for that, I suggest you to look around in the forum and documentation for calendar subject.
Hope this help.
