So what I want is initially user can pass the merchant number and columns he need and then quicksight will generate report . Like he has option to select from 50 column he can select whatever he wants
Hi @deepa.singh ,
It sounds like you would like to have dynamic dimensions for your visual. Is that correct? If so, I would recommend checking out these resources:
- This is a previous community post that is a similar question to yours that could be useful (Creating a dynamic pivot table where the value field can be controlled with a dropdown - Q&A - Amazon Quick Community).
- Now this resource, while it is not a table/pivot table visual, the underlying mechanics are very useful to use as reference. To open the analyses, look for the
icon on the left hand side panel. From there, you’ll be able to see how the dynamic dimensions and measures were put in place. Here is the link (DemoCentral).
Check out these resources and let me know if you are still running into some troubles.
Hi @deepa.singh,
Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.
If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
Thank you
Hi @deepa.singh,
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Thank you