Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have data in the below format:
Task | Comments | Date |
BBPLC for Swap | 01 Oct: - Migration of Non US Population off BCSL | 10/20/2016 |
BBPLC for Swap | 01 Oct: - Migration of Non US Population off BCSL | 10/19/2016 |
BCI -Enhancement | 12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready | 10/20/2016 |
BCI -Enhancement | 12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready | 10/19/2016 |
and i want to create a pivot table which will display the result as the below format:
Task | Comments | Date |
BBPLC for Swap | 01 Oct: - Migration of Non US Population off BCSL | 10/20/2016 |
01 Oct: - Migration of Non US Population off BCSL | 10/19/2016 | |
BCI -Enhancement | 12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready | 10/20/2016 |
12 Oct: -House Position and House ladder protype ready -Actuals Vs Projections Reconciliation and MTM prototype ready | 10/19/2016 |
Where Date is sorted with recent date and Date column is hidden
please advise
thanks
Sukhwant
Any update on this please
Can you attach the sample data?
its there in the body. feature not active to upload info
thanks
The pivot table should have dimensions Task and Comments, where Comments is sorted by expression based on Date.
You still need an expression for the table, at least a "blank expression".
Pivot table works with drop down select.
So if you add Task and Comments as dimension.
Use if condition Date as Calculated Dimension if you want to hide dates.
But you always need to have at least 1 expression to populate the pivot table.
what about this solution?
hope this helps
I am not sure if you are looking this, But hope this might you are expecting
So that, you can create Pivot Table with the Dim of Task, Date
Expression is : SubField(Comments,'-',1) & Chr(10) & '-' & SubField(Comments,'-',-1)
OR
You can use Dimensions are Task, Date
Expressions are : 1) SubField(Comments,'-',1) & Chr(10) & '-' & SubField(Comments,'-',-1)
2) Date
Then, you can create one Macro to hide the Dimension like below
FUNCTION HideColumn(ch, n)
set ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1),0
set ch = Nothing
END FUNCTION
SUB ColHide
call HideColumn("CH01", 2)
END SUB
sub kache
ActiveDocument.ClearCache
MSGBOX "OK Cache"
END SUB
After This, you will get this Image
Hi,
Load the data into QV.
Create one Pivot table:
1. Table Pivot
2. dimension(Task, Comments)
3. Expression(Only(Date))
Now Pivot table will be as expected.
Coming to Sort, Double click on the Date column for sorting as per the requirement.
excellent thanks a lot.
But require just one more thing, if for different dates the comments are the same, so want to show only 1 comments,
how can we do that