Get grouped data from categorical data

Hi everyone,

I have categorical data view mapping with date as category, name as group and number as value.

How can I get data in such way, that I can plot different item as different line?

This is similar to regular line chart, but I can't use it, since I need cumulative values and I cant do it with live connection to OLAP cube.

Regards,

Yerkhan