DataPilot, Sum of medians total result, not median of median

Discuss the spreadsheet application

DataPilot, Sum of medians total result, not median of median

Postby fleal26 » Wed Jul 11, 2018 4:36 pm

In a DataPilot, I want the total result column to be the sum of medians, but i can only get it to give me the median of the medians.

The data for the the datapilot is some entries for the processing time of specific products on different parts of the total process (like painting, machining...), so the sum of the medians of each of this times would give me the total processing time of the product, however I can only get OpenOffice to give me the median of all the medians.
OpenOffice 4.1.1 on Windows Vista
fleal26
 
Posts: 2
Joined: Wed Jul 11, 2018 4:10 pm

Re: DataPilot, Sum of medians total result, not median of me

Postby robleyd » Thu Jul 12, 2018 3:00 am

Can you upload a sample spreadsheet with pivot table that demonstrates your issue?

[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1748
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: DataPilot, Sum of medians total result, not median of me

Postby fleal26 » Fri Jul 13, 2018 8:32 pm

On the DataPilot (2nd sheet), I want D7 (total result) to be the sum of D5 and D6.
But I can only get it to give me the median.
Attachments
1.ods
(15.9 KiB) Downloaded 11 times
OpenOffice 4.1.1 on Windows Vista
fleal26
 
Posts: 2
Joined: Wed Jul 11, 2018 4:10 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 33 guests