Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I have to create one column in dashboard based on my data.
I/p table
ID coss Markets M1 M2 M3 M4...M20 Secure S1 S2 S3
1. ×
2. ×
3. ×. ×
4. ×. ×. ×
5. ×. ×. ×. ×
My o/p looks like
ID Impati
1. Coss
2 Markets
3 Markets: M1
4 Markets: M1,M4
5. Markets: M1,M2& Secure
I want to show names where we have ×
How can I achieve this
Hi,
I reckon you will be best looking at this in script and your the Cross table Function.
You should be able then get it usable data and display as you require.
Hi Mark thanks for your reply.i have used cross table function but Iam unable to write logic.can u please help me on this.can u take this example and try it how to write logic.Its much needed Iam struggling alot