This content has been marked as final. Show 2 replies
i have 2 tables:
date, value2, type
i want my pivot chart like this:
dimensions: date, type
expr : sum(value1), sum(value2).
value2, looks ok, but value1 has the problem because there is no type dimension in the source.
how can i split the sum of value1 into type, based on the ratio between types based on the sum of value2 of that day?