I need help on calculating the counts from the rawdata based on conditions and then I need to insert the values in the summary table. Currently, I have the values stored in rawdata format and I need get the counts in the summary table.
Please let me know the best approach to get this task done. I can give more information if this is not clear.
You're starting with a pivoted data set, and you want to pivot it differently - so, you want to unpivot it to a natural set, then re-pivot it to the set you want. This gives you what you want, but it doesn't match your sample, because your sample summary is wrong...
answered Jun 07 '10 at 07:05 AM
Matt Whitfield ♦♦