Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm on qv 9 and I need help with defining the expresssion for a straight table chart.
Sample Data
recId | category | attribute1 | fieldA | fieldB |
---|---|---|---|---|
1 | A | Y | AAA | YYY |
2 | A | Y | ZZZ | BBB |
3 | A | Y | CCC | WWW |
4 | A | Y | EEE | FFF |
5 | A | N | GGG | HHH |
Desired Output
Cateogry | attribute1 | maxString(fieldA) | fieldB value on maxString(fieldA) row |
---|---|---|---|
A | Y | ZZZ | BBB |
A | N | GGG | HHH |
cateogry and attribute1 are dimensions and maxString(fieldA), fieldB value opf maxString(fieldA) row are expressions.
Thanks
Tony
Hi,
Pls. see the attached file, I hope it helps.
Best regards,