2 weeks ago - last edited 2 weeks ago
Hi,
In cross table, we can have 1 dimension on top and 1 dimension on side, so that the function of percentage([measure name];Col) would distribute by column (example as image 1, 2024-09 has 1 in total). However, when it is using a vertical (or horizontal) table, the percentage is always shared among all mix of dimension 1 & dimension 2 (example as image 2, percentage distributed for the entire column 3). Any syntax or operator that can be made good use to give the column 3 in image 2 distributed as image 1?
Meanwhile, if I need it on a chart, how to make it distributed month by month (ideally to be something like image 3)?
image 1:
image 2:
image 3:
use the [Dimension 1] as a break in the percentage you use.
Percentage(measure[;Break][;Row|Col]
for Examples, see help for "Percentage"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.