Stacked bar not calculating correct percentage as excel

Hi Everyone,

I have attached excel and spotfire worksheet. It's a data for product category by their order # which is not unique.

I want to create a stacked bar that shows correct percentages allocation as excel (Pivot sheet)

When I am creating this in spotfire it gives me wrong factor. E.g. OT is 45% which is 47% in excel. 

How can I achieve this?

Thank you so much for your time.

Thanks,

Arpitha

 

 

Attachments

AttachmentSize
File spotfire_sample.xlsx98.9 KB
Binary Data spotfire_sample_-_data.dxp246.6 KB

(1) Answer

Login