I have a sheet, the original data base, that I don’t want to touch.
I have a dynamic table that presents data in different ways, like averages.
I have a Weight column in original data base expressed as pounds, I want to display them as Kg.
Is it possible to leave the value on original cells written as it is, and just render them as Kg in dynamic table?
Update: the proper name for dynamic table may be pivot table. Sorry, I don’t have my LibreOffice in English. What I want is not having to sanitize the original database, and just make pivot table display weights as Kg. Can it be done?