Skip to Content
0

Merge Counts in Bar Chart

Apr 07 at 11:06 AM

21

avatar image

Hi Experts,

Could you please help on the below key figure formulae to merge counts of similar dept to show single bar for attached bar charts.

Category Axis: (2 dimensions)

=[Dept]

= [Calenday Day] --- Hidden dimension

Value Axis 1 : (1 Keyfigure)

= [Count(([name].Key);Distinct)]

Thanks,

Dinya

capture.jpg (13.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers