Forum Discussion
How to create column as a input for report
Hi Team,
Please help on bellow issue. In my case i need to use column name as a filter in report.
1. Have input like bellow
2.Need out put report like bellow
3. And filter like bellow
When am select "Country" filter need to show data related to Country
5 Replies
ryan_mayuSuper User
Anonymous
in the pq, select region, country and group , unpivot column
then you can use attribute column as a filter
- ryan_mayu
Anonymous
I am sure about this because I didn't try the direct import. Please have a try to see if you encounter any issues.
- amitchandak
Anonymous , You can import this table. Either you can convert to star schema and have dimension for region country and groups (one or more dimension based on need).
Or you can use them directly has filter.
You can put required column in table visual and it should do
