Wanted to practice drill down, so created Excel sheet with Quarters, Months, and Weeks (1-4, Jan-Feb, 1-52) and some income and expense figures:
In my Excel sheet, July looks like this:
3
July
26
0
0
0
3
Juy
27
1200
300
500
3
July
28
0
0
0
3
July
29
1200
300
500
3
July
30
0
0
0
However, when I loaded the table and tried to create chart, two "July" entries show up. One bar is week 26 AND weeks 28,29,30. The other bar is only week 27. If I go to the tables in the QV sheet, and click on July in the Month table, it highlights 26, 28, 29, 30 in the week table, but not 27. On the other hand, when I click on week 27 in the Weeks table, it highlights July in the Month table. I've reloaded several times, re-entered and saved the data in Excel, but the same thing keeps happening. Any ideas?
