View My Drafts
Kære Alle, håber nogen kan hjælpe os på vej med følgende.We are trying to find a way to distribute the values of one column in a chart to the others based on the size of the other columns.
Say we have one column with turnover from webshop sales, and some other columns with sales for a number of stores. We want to be able to destitute the webshop turnover to the physic shops for accounting reasons. Preferably we would like to do it on row basis, so that it is still possible to divide sales by product.
Can somebody please help us giving their thought on where the solution should be performed, in the visualization, as a calculated column etc.