Can anyone explain how Table Visuals figure out the Total line? In my example, Product has the wrong Total. Product is defined as C% * P%. Is it multiplying Total C% by Total P%? Is it adding up hidden rows of Product?
I'm also concerned that the other totals are just accidently correct; C% and P% should each add up to 1. Did it sum the values in the table or did I do some other operation that just happened to be the answer I expected?
Expected:
Total Product = 0.35
Actual:
Total Product = 1
Setup:
Data Source: Has 450 rows.
[Upper] is a Column.
[Count] is Measure.
[Paid] is Column.
[C%] = [Count]/(All [Count])
[P%] = [Paid]/(All [Paid])
[Product] = [C%] * [P%]
Data:
| Upper | Count | Paid | C% | P% | Product |
|---|---|---|---|---|---|
| A | 60 | $400 | 0.13333 | 0.22222 | 0.029630 |
| B | 150 | $850 | 0.33333 | 0.47222 | 0.157407 |
| C | 240 | $550 | 0.53333 | 0.305556 | 0.162963 |
| Total | 450 | $1800 | 1 | 1 | 1 |