Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HELLO
I need help!
I have a table called work scheduled on that table have a date which shows the progress of these works, but dates until 2019 mark
my table and mark the progress of these current record is 2015, every 15 days made a cut on the progress of the work, so my log table has cut eg
01/15/2015
30/01/2015
02/01/2015
15/02/2015
up to: 31/08/2015
as I can do to show in a pivot table only the last 3 months or 6 cuts last 15 days records progress:
for instance:
15.06.2015,
06/30/2015
15/07/2015
07/31/2015
08/15/2015
08/31/2015
but only consider the records of progress of works and not consider the records until it reaches the scheduled work to date = 2019
Thank you
please post a sample
Thank you
looking send you a picture of my tables is related by date, day, month,
My table shows programmed works scheduled dates of the works that reach 2019
My table shows the dates forward Real progress leading every 15 days, and then get through 2016. I want is that in the date field when placed in the pivot table only shows me the three months of the progress of works
colo an image like this my pivot table and show me the dates to the year 2009-2019
I just need to show the dates for example:
15/06/2015
06/30/2015
15/07/2015
31/07/2015
15/08/2015
31/08/2015
Hi,
Can you share the sample file to demonstrate your issue? Thank you.
Hi,
Can you post ur qvw.
sorry but the information is confidential I can not share, but I think it came shares allocated to them what dimensions add an added dimension and place this:
= if (FechaMaxAvance <= Today () and FechaMaxAvance> = (Today () - 60), FechaMaxAvance)
and this gives me the last 4 cuts of the current fortnight, and I hope this good, or someone knows another solution? just know to get more knowledge
and thank you very much for your attention