I am new to Tableau , using 8.3 version
I have two different source (Oracle and Excel)
I have created custom relationship between both the source and simple division calculation is done. calculated values are perfect but if add sub total and column grand total i am getting wrong values.
can anyone please help on this issue.
Grand totals don't calculate on the aggregates in a view but instead from a much higher level of granularity. This post perfectly sums it up: