I need value mapped with a particular date

[saumyashah90]

Hi Guyz i have a table:

What i need is.

I have a Date Separately called (23/06/2014)

like

These dates will keep on changing every day or week.So i need their hours to be displayed accordingly

And these Dates you can take as text values generated by some expression.

I used Substringcount

If(SubStringCount(Date#(Dt,'DD/MM/YYYY'),WeekStart(Today()))>0,Hours)
Also tried WildMatch but didnt succeed.

[saumyashah90]

Hi Priyanka,

I am already able to get this in pivot table.

Request you to limit these dates for only one week (current week).

Week dates should change in next week

[saumyashah90]

Not Working

[saumyashah90]

Hi Yogesh,

This solutions looks feasible but not working on mine.. might be the table i have used is crosstable

[bariyb23]

Can you share sample application

[#6]

Hi Saumya,

You can use Week() function to compare and fetch the result.

I have modified the Date List, Here I have 30/06/2014 and 31/06/2014 as the values in the list.

Now, since today is 30/06/2014, hence the chart is showing the present Week's data ie. 30/06/2014 and 31/06/2014.

I have attached the sample file for you assistance.

Hope it helps !

Regards.

[PradeepReddy]

See the attachment... it might be help full for you..

If you select the date from list box,it produces the data for all the 5 days(Monday-Friday) & total..

By default it takes the Latest week data.

Regards,

Pradeep

[saumyashah90]

Thats what i dont want...i need not do any selection and it should display data for current week.

[PradeepReddy]

if you don't select any date.. , it will show the default data for the current week..

[PradeepReddy]

Please check the attached file..

by default it shows the current week data...

[saumyashah90]

It shows data from 23rd.

Right now current week going on should be from 30/6/2014