Stacked bar not calculating correct percentage as excel
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.