Skip to Content
-1

How to get Aggregated and Dinstict Values using Calculation View?

Nov 09, 2017 at 08:53 AM

10

avatar image
Former Member

Hi Experts, i have a table below, and would like to achieved the expect output below, could you please guide me how to achieve using Graphical Calculation View?

Table

Customer| F1| F2 |F3

0001 |X||X

0001 ||X| X

0002 X||

0002 ||X

Expected Output

0001 |X|X|X

0002 X||X

The output only contains 2 lines of distinct value and should indicate the Xs for the 3 fields if there is any line has been X for the field.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers