Hi Friends,
I have below tables
KEY | STYLE | DESCRIPTION |
1 | A | 1 |
2 | A | 2 |
3 | B | 3 |
4 | B | 4 |
Could you guys advise me how to separate it with <<Start>> <<End>> expression to below 2 thinner tables ? ( I'm trying to do this for Email Body Template )
STYLE : A
KEY | DESCRIPTION |
1 | 1 |
2 | 2 |
STLYE : B
KEY | DESCRIPTION |
3 | 3 |
4 | 4 |
Solved! Go to Solution.
Assuming the table is called "Styles":
<<Start:
Style: <<Style>>
Key | Description |
<<Start: FILTER( Styles, [Style]=[_THISROW].[Style] ) | <<Description>><<End>> |
<<End>>
Please change [_THISROW] with [_THISROW-1] on either expression if it doesn't work, I tend to forget the logit sometimes about it's usage. And I found it unreliable sometimes
User | Count |
---|---|
18 | |
12 | |
8 | |
4 | |
3 |