Dynamic display of columns

How to display columns in a list based on prompt selection. For example display Revenue or Gross profit based on user selection?

Answer:
There are multiple ways to achieve this. This could be achieved by using conditional statements, using variables or conditional blocks. We are proposing here the most efficient process of all.

1. Create a List report with the required columns
2. Create a prompt with Static choices as ‘Revenue’ and ‘Gross profit’
3. Add a query calculation with the expression #prompt(‘Parameter Name’, ’token’)# in your list

You are all set!!!!!!!!!!!!!!!!!!!!!
Note: we will write more about token prompting in the next blogs