You can create both Straight Table and Pivot Tables without Expressions -- they would have Dimensions only. You just need to uncheck "Suppress zero Values" on the Presentation tab. It's very handy, especially as an alternative to Table Box.
I like to analyse the Target and Current Revenue.Below is the scenario,
Current Revenue per month- 80,000
My target -1,00,000
Travelling Expenses-10,000
Electricity Charges -3000
Other Expenses -1000.
My Questions is that:
I have a Gauge Chart where One end will display the Current Revenue and opposite will display the Target which I want to achieve.i have three slider control in which Travelling expenses amount,Electricity charges amount and Other Expenses amount are assigned.
If i decreases the Expenses in slider, then automatically my Current Revenue have to increases and
should moves to the target.How can i do this.Give me the code to do it.Please help me.
Any time you just want to display the data, without summarizing any measures. For example, showing a detail table, like Customer Name / Address, etc. Think of an expressionless straight table as an alternative to a Table Box -- but with better styling options and the potential to add an expression later if need be.
As a matter of course, I use Expressionless Straight tables instead of Table Boxes.
Or use a Dimension Only Pivot table to show a Hierarchy, Like Manager & Staff, or Product Category/ Subcategory/ Product.
Also useful is a Straight Table with no Dimensions, just Expressions
