Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Simple monthly reporting - chronology issue

Hi there !

 

I'm struggling to achieve a simple reporting by month. And I hope you might help me.

 

What I have done so far is pretty basic:

- ASSET tale, with all the assets details and a Unique ID, ordered by columns (each line is a unique ID, corresponding to a type of asset and its specifics)

- DATE table, with a date format column and a month column

- JANVIER (January) and FEVRIER (February) tables contains a column with Unique IDs, a corresponding value, and a DATE (each DATE entry for January are 01/01/2019) as I'm gathering data each month.

 

I would like to add each months a new table, with the same formatting and update the report.
What I don't understand is how to have chronology. 

Have you encounter this already ?
Thanks in advance !!!
(If it has been answer somewhere else, please post the link and give me a virtual head tap :smileylol: )

 

Need Help

2 Replies

  • fahmi_laswar's avatar
    fahmi_laswar
    Frequent Visitor
    7 years ago

    Hi

    can you give us current simple date , and simple of result you want ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,
      I used dates such as 01/01/2019. Wich is equivalent to JANUARY 2019 in my table.

      I'm trying to creat a proper DATE table at the moment.

      I think I should use contiguous date for a table to be used a date table.

      I would like to add each month a table with the values for my assets and link it with the DATE table so I am able to see the evolution month by month.