Mekala B Posted June 25, 2019 Share Posted June 25, 2019 Hi I have data as below: Group Sub_group Date item Status Group1 VA 2019-06-05 GVA1 0 Group2 SB 2019-06-05 GBA1 0 Group3 JKLP 2019-06-06 JGL 1 Group2 SPT 2019-06-07 JKL 0 Group3 LY98 2019-06-08 PAU 1 Group2 SB 2019-06-08 MKO 1 I want to pivot data such as to see sum of Status My desired pivot table should be as below: Row Labels 2019-06-05 2019-06-05 2019-06-07 2019-06-08 2019-06-06 2019-06-08 Group1 0 VA 0 GVA1 0 Group2 0 0 1 SB 1 MKO 1 SPT 0 JKL 0 SB 0 GBA1 0 Group3 1 1 JKLP 1 JGL 1 LY98 1 PAU 1 Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted June 25, 2019 Share Posted June 25, 2019 Insert/Transformations (pre Spotfire X) or Data/Transform data (Spotfire X) to add a Pivot transformation Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now