Skip to Content
avatar image
-1
Former Member

How to get Aggregated and Dinstict Values using Calculation View?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers