What is Dummy Dimension?explain with example?
If I understand you correctly, you are referring dummy dimension as a field which is not available in your DB.
You can use ValueList(column1,column2..), ValueLoop() functions to get the desired results..
Also, you can use Calculated Dimension (but it may result single value)..
please sir forward me some example for better understanding...!
Refer these docs...
can i get dummy dimension for MonthYear data
How to add dummy dimension in Pivot level chart
Hope this will help
Retrieving data ...