Weekly and YTD Value in combo chart

[ishanbansal1204]

Hi Experts,

I have a combo chart where the dimensions are week and then the first measure that i am using is the sum(count) at  a week level

but i am not getting the YTD value

e.g.

for weeek 1 value will be 10 and YTD will be10

for week 2 value will be 20 and YTD will be 30

THis should be grouped at week and year level.

I have attached the sample file.

[tresesco]

Could you share your sample qvw?

[ishanbansal1204]

Hi tresesco,

I dont have any.

Have one which has my project. I am sorry cannot share you those details.

[tresesco]

You can create a sample and upload. Check this :

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[antoniotiman]

Like this

[ishanbansal1204]

I Have shared the Excel file. you want me to share the qvf file as well?

[eromiyasimon]

Hi,

The below expression shows the value which you requested.

rangesum(Above(Total sum(COUNT),0,RowNo(Total)))

attached the QVW for further reference.

Hope this helps

[antoniotiman]

See Attachment

Regards,

Antonio

[ishanbansal1204]

Hi Antonio,

There is no attachment.

[antoniotiman]

??