pivot table sum(total) question

[Anonymous]

Hello,

I have a table like this

A pivot table has lastShipDateYW and Time2FWeek as dimensions. The expression is the total count of unique subsetID

I would like to know how to add a column which has total count of subsetID in lastShipDateYW and a row which has total count of Time2FWeek, like

How to do it?

thanks,

Josh

[sunny_talwar]

Josh - You don't expect to provide you with a sample to this without looking at an application. I don't even know your data well enough and the images makes it even more complicated. Look at these threads and see if you can provide a sample

QlikCommunity Tip: How to get answers to your post?

Qlik Community Tip: Marking Replies as Correct or Helpful

Uploading a Sample