Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
i am facing a critical situation in pivot table view to freeze dimension from calender selection.
I have multiple dimensions and only one expression.i want to ignore all dimensions (retain all dimension values) from calender selection but want expression value to change as per calender selection. for example
i have 10 dimension and no of records in each dimension=50
i have 1 expression and number records are depends on calender selection.
i want to fix 10 dimension with 50 number of records and want to show expression value on calender selection basis.
so kindly help me friends
Pawan Panwar
Consider below example..
You have dimensions as
Customer
Country
Brand
Supplier
Expression = SUM(Sales)
If you want your SUM(Sales) only change if there are some selection or changes in Calendar field
i.e. Date, Month, Year, Quarter etc
But not due to change in Customer, Country, Brand, Supplier....
You can change you Expression as below...
SUM({$<Customer = , Country = , Brand = , Supplier = >}Sales)
i.e Your value for particular dimension will not change if you use your dimension in expression under set analysis as above...
Hi Manish,
There is some mis understanding i want freeze the dimension value.
E.g. If we have 50 rows(values) in dimentions then they must be 50at all times regardless of what calendar selection is. Also only expression values should change in case of change in calendar selection and if there is some mismatch with dimension values it should return 0 or null.
Please suggest.
Regards
Pawan Panwar
can you provide little sample data with your requirements?
Before calender salection value
Group2 Group3 SaleAmount
AHD AEGIS1 13659.12
AHD AHD1 2273646.87
AHD AHD1A 9736.49
AHD AHD5 469956.43
AHD AHD5A 30832.46
AHD AHD32 120350.27
AHD AHD60 376254.3
AHD AHD66 232544.35
AHD AHD67 3.55
AHD AHD78 85093.17
AHD AHD82 0.73
AHD AHD83 167265.92
AHD AHD84 304973.73
AHD AHD86 126707.21
AHD AHD89 166495.72
AHD AHD97 63685.52
AHD AHD99 157665.35
AHD AHD101 795121.37
AHD AHD106 171938.2
AHD AHD111 925982.06
AHD AHD118 4872.95
AHD AHD120 939.84
After selection value shown as
Group2 Group3 SaleAmount
AHD AEGIS1 1659.12
AHD AHD1 646.87
AHD AHD1A 9736.49
AHD AHD5 956.43
AHD AHD5A 832.46
AHD AHD32 350.27
AHD AHD60 54.3
AHD AHD66 544.35
AHD AHD67 3.55
AHD AHD78 93.17
AHD AHD82 0.73
AHD AHD83 7265.92
AHD AHD84 4973.73
but i need the dimension value is same even if there is no value for a dimension in expression
want to show same as below(all dimension records to remain on the grid if there is not value from the expression)
Group2 Group3 SaleAmount
AHD AEGIS1 1659.12
AHD AHD1 646.87
AHD AHD1A 9736.49
AHD AHD5 956.43
AHD AHD5A 832.46
AHD AHD32 350.27
AHD AHD60 54.3
AHD AHD66 544.35
AHD AHD67 3.55
AHD AHD78 93.17
AHD AHD82 0.73
AHD AHD83 7265.92
AHD AHD84 4973.73
AHD AHD86 0
AHD AHD89 0
AHD AHD97 0
AHD AHD99 0
AHD AHD101 0
AHD AHD106 0
AHD AHD111 0
AHD AHD118 0
AHD AHD120 0
Regards
Pawan Panwar
Under Dimension Tab
Select Show All Values
Under Presentation Tab
Untick Suppress Zero Values
After done that result shown as
Group2 Group3 SaleAmount
AHD AEGIS1 1659.12
AHD AHD1 646.87
AHD AHD1A 9736.49
AHD AHD5 956.43
AHD AHD5A 832.46
AHD AHD32 350.27
AHD AHD60 54.3
AHD AHD66 544.35
AHD AHD67 3.55
AHD AHD78 93.17
AHD AHD82 0.73
AHD AHD83 7265.92
AHD AHD84 4973.73
- AHD86 0
- AHD89 0
- AHD97 0
- AHD99 0
- AHD101 0
- AHD106 0
- AHD111 0
- AHD118 0
- AHD120 0
But I required same as below
Group2 Group3 SaleAmount
AHD AEGIS1 1659.12
AHD AHD1 646.87
AHD AHD1A 9736.49
AHD AHD5 956.43
AHD AHD5A 832.46
AHD AHD32 350.27
AHD AHD60 54.3
AHD AHD66 544.35
AHD AHD67 3.55
AHD AHD78 93.17
AHD AHD82 0.73
AHD AHD83 7265.92
AHD AHD84 4973.73
AHD AHD86 0
AHD AHD89 0
AHD AHD97 0
AHD AHD99 0
AHD AHD101 0
AHD AHD106 0
AHD AHD111 0
AHD AHD118 0
AHD AHD120 0
your sample apps will be helpful to check and give you answer..
i will send you on monday. thanks for support.
Hi Manish,
kindly find attached sample qvw.
I want same output of dimension on calander selection as(without selection) but want to change only in expression on calander selection.
Regards
Pawan Panwar