Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
There is a thing and it' s disappointing that i couldn't find a solution yet. which is:
- there are weeks in fields like week1, week2, week3 to week 57
- there is a year field containing 2010 to 2013.
i decreased these 52 fields of weeks to two fields using cross table, and now i have a week field and it contains weeks like:
Week
Week1
Week2
-
-
-
-
When i use pivot table i use week and data fields as a dimension and with a year listbox i can list the values for an nth week of x year.
I' ve merged this week and year fields (weekyear). But after this operation, i cant see the week and year' s (weekyear) value as i can see the week values in table.
The table exists empty.
I wonder if someone can help me with this situation. any help would be very appreciated.
Thanks a lot, regards,
Ozzyefendi.
Hi,
Can you attach the sample file you are working?
Regards,
Jagan.