Got a problem that's been beat to death on the forums and I'm still stuck! I've got a sample QVW attached of what I'm trying to do, but it's basically this:
I've tried an aggregation formula, but that only provides the total on one row. Is there a way to accomplish this in the table, or should I modify the load script to accumulate hours by month?
Create a straight table with Month and Name as dimensions and
Sum([Hours Worked]) and Sum(TOTAL <Month> [Hours Worked]) as expressions.
The second expression will give the desired result.
View solution in original post
Genius, thank you!